﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="ESRPDataSetComenziNeonorate" targetNamespace="http://tempuri.org/ESRPDataSetComenziNeonorate.xsd" xmlns:mstns="http://tempuri.org/ESRPDataSetComenziNeonorate.xsd" xmlns="http://tempuri.org/ESRPDataSetComenziNeonorate.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="ESRPConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="ESRPConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.Fares.Properties.Settings.GlobalReference.Default.ESRPConnectionString" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="fares_viewComenziNeonorateTableAdapter" GeneratorDataComponentClassName="fares_viewComenziNeonorateTableAdapter" Name="fares_viewComenziNeonorate" UserDataComponentName="fares_viewComenziNeonorateTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ESRPConnectionString (Settings)" DbObjectName="ESRP.dbo.fares_viewComenziNeonorate" DbObjectType="View" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Fill" GenerateShortCommands="false" GeneratorSourceName="Fill" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT IDDocumentDetaliu, IDArticol, Cantitate, ValoareUnitara, IDUnitateMasura, TermenLivrare, Observatii, ValoareUnitaraValuta, NrDoc, DataDoc, CodValuta, CantitateReceptionata, CantitateRamasa, CodUnitate, IDPartener, IDTipDocument FROM fares_viewComenziNeonorate WHERE (CodUnitate = @CodUnitate)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="CodUnitate" ColumnName="CodUnitate" DataSourceName="ESRP.dbo.fares_viewComenziNeonorate" DataTypeServer="smallint" DbType="Int16" Direction="Input" ParameterName="@CodUnitate" Precision="0" ProviderType="SmallInt" Scale="0" Size="2" SourceColumn="CodUnitate" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="IDDocumentDetaliu" DataSetColumn="IDDocumentDetaliu" />
              <Mapping SourceColumn="IDArticol" DataSetColumn="IDArticol" />
              <Mapping SourceColumn="Cantitate" DataSetColumn="Cantitate" />
              <Mapping SourceColumn="ValoareUnitara" DataSetColumn="ValoareUnitara" />
              <Mapping SourceColumn="IDUnitateMasura" DataSetColumn="IDUnitateMasura" />
              <Mapping SourceColumn="TermenLivrare" DataSetColumn="TermenLivrare" />
              <Mapping SourceColumn="Observatii" DataSetColumn="Observatii" />
              <Mapping SourceColumn="ValoareUnitaraValuta" DataSetColumn="ValoareUnitaraValuta" />
              <Mapping SourceColumn="NrDoc" DataSetColumn="NrDoc" />
              <Mapping SourceColumn="DataDoc" DataSetColumn="DataDoc" />
              <Mapping SourceColumn="CodValuta" DataSetColumn="CodValuta" />
              <Mapping SourceColumn="CantitateReceptionata" DataSetColumn="CantitateReceptionata" />
              <Mapping SourceColumn="CantitateRamasa" DataSetColumn="CantitateRamasa" />
              <Mapping SourceColumn="CodUnitate" DataSetColumn="CodUnitate" />
              <Mapping SourceColumn="IDPartener" DataSetColumn="IDPartener" />
              <Mapping SourceColumn="IDTipDocument" DataSetColumn="IDTipDocument" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="ESRPConnectionString (Settings)" DbObjectName="ESRP.dbo.fares_viewComenziNeonorate" DbObjectType="View" FillMethodModifier="Public" FillMethodName="FillByArticol" GenerateMethods="Fill" GenerateShortCommands="true" GeneratorGetMethodName="GetDataBy" GeneratorSourceName="FillByArticol" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="FillByArticol">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT Cantitate, CantitateRamasa, CantitateReceptionata, CodUnitate, CodValuta, DataDoc, IDArticol, IDDocumentDetaliu, IDPartener, IDTipDocument, IDUnitateMasura, NrDoc, Observatii, TermenLivrare, ValoareUnitara, ValoareUnitaraValuta FROM fares_viewComenziNeonorate WHERE (CodUnitate = @CodUnitate) AND (IDArticol = @IDArticol) AND (IDTipDocument = @IDTipDocument)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="CodUnitate" ColumnName="CodUnitate" DataSourceName="ESRP.dbo.fares_viewComenziNeonorate" DataTypeServer="smallint" DbType="Int16" Direction="Input" ParameterName="@CodUnitate" Precision="0" ProviderType="SmallInt" Scale="0" Size="2" SourceColumn="CodUnitate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="IDArticol" ColumnName="IDArticol" DataSourceName="ESRP.dbo.fares_viewComenziNeonorate" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@IDArticol" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="IDArticol" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="IDTipDocument" ColumnName="IDTipDocument" DataSourceName="ESRP.dbo.fares_viewComenziNeonorate" DataTypeServer="smallint" DbType="Int16" Direction="Input" ParameterName="@IDTipDocument" Precision="0" ProviderType="SmallInt" Scale="0" Size="2" SourceColumn="IDTipDocument" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="ESRPConnectionString (Settings)" DbObjectName="ESRP.dbo.fares_viewDocumenteStocuriIntrate" DbObjectType="View" FillMethodModifier="Public" FillMethodName="FillByArticolStoc" GenerateMethods="Fill" GenerateShortCommands="true" GeneratorSourceName="FillByArticolStoc" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy1" UserSourceName="FillByArticolStoc">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT IDDocumentDetaliu, IDArticol, Cantitate, ValoareUnitara, IDUnitateMasura, TermenLivrare, Observatii, ValoareUnitaraValuta, NrDoc, DataDoc, CodValuta, CantitateReceptionata, CantitateRamasa, CodUnitate, IDPartener, IDTipDocument FROM fares_viewDocumenteStocuriIntrate WHERE (CodUnitate = @CodUnitate) AND (IDArticol=@IDArticol)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="CodUnitate" ColumnName="CodUnitate" DataSourceName="ESRP.dbo.fares_viewDocumenteStocuriIntrate" DataTypeServer="smallint" DbType="Int16" Direction="Input" ParameterName="@CodUnitate" Precision="0" ProviderType="SmallInt" Scale="0" Size="2" SourceColumn="CodUnitate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="IDArticol" ColumnName="IDArticol" DataSourceName="ESRP.dbo.fares_viewDocumenteStocuriIntrate" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@IDArticol" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="IDArticol" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="ESRPConnectionString (Settings)" DbObjectName="ESRP.dbo.fares_viewComenziNeonorate" DbObjectType="View" FillMethodModifier="Public" FillMethodName="FillByPartener" GenerateMethods="Fill" GenerateShortCommands="true" GeneratorGetMethodName="GetDataBy1" GeneratorSourceName="FillByPartener" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy2" UserSourceName="FillByPartener">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT Cantitate, CantitateRamasa, CantitateReceptionata, CodUnitate, CodValuta, DataDoc, IDArticol, IDDocumentDetaliu, IDPartener, IDTipDocument, IDUnitateMasura, NrDoc, Observatii, TermenLivrare, ValoareUnitara, ValoareUnitaraValuta FROM fares_viewComenziNeonorate WHERE (CodUnitate = @CodUnitate) AND (IDPartener = @IDPartener) AND (IDTipDocument = @IDTipDocument)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="CodUnitate" ColumnName="CodUnitate" DataSourceName="ESRP.dbo.fares_viewComenziNeonorate" DataTypeServer="smallint" DbType="Int16" Direction="Input" ParameterName="@CodUnitate" Precision="0" ProviderType="SmallInt" Scale="0" Size="2" SourceColumn="CodUnitate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="IDPartener" ColumnName="IDPartener" DataSourceName="ESRP.dbo.fares_viewComenziNeonorate" DataTypeServer="bigint" DbType="Int64" Direction="Input" ParameterName="@IDPartener" Precision="0" ProviderType="BigInt" Scale="0" Size="8" SourceColumn="IDPartener" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="IDTipDocument" ColumnName="IDTipDocument" DataSourceName="ESRP.dbo.fares_viewComenziNeonorate" DataTypeServer="smallint" DbType="Int16" Direction="Input" ParameterName="@IDTipDocument" Precision="0" ProviderType="SmallInt" Scale="0" Size="2" SourceColumn="IDTipDocument" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ArticoleTableAdapter" GeneratorDataComponentClassName="ArticoleTableAdapter" Name="Articole" UserDataComponentName="ArticoleTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ESRPConnectionString (Settings)" DbObjectName="ESRP.dbo.Articole" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [Articole] WHERE (([IDArticol] = @Original_IDArticol) AND ([CodArticol] = @Original_CodArticol) AND ([Denumire] = @Original_Denumire) AND ([IDCategorie] = @Original_IDCategorie) AND ([CodUnitate] = @Original_CodUnitate) AND ([IDUnitateMasura] = @Original_IDUnitateMasura) AND ([Cont] = @Original_Cont) AND ([ContCheltuiala] = @Original_ContCheltuiala) AND ([Greutate] = @Original_Greutate) AND ([CotaTVA] = @Original_CotaTVA) AND ([EsteServiciu] = @Original_EsteServiciu) AND ((@IsNull_ContVenit = 1 AND [ContVenit] IS NULL) OR ([ContVenit] = @Original_ContVenit)) AND ([PretVanzare] = @Original_PretVanzare) AND ((@IsNull_ArtAl = 1 AND [ArtAl] IS NULL) OR ([ArtAl] = @Original_ArtAl)) AND ([PretVanzareValuta] = @Original_PretVanzareValuta) AND ([PretVanzareCodValuta] = @Original_PretVanzareCodValuta) AND ([MateriePrima] = @Original_MateriePrima) AND ((@IsNull_Lungime = 1 AND [Lungime] IS NULL) OR ([Lungime] = @Original_Lungime)) AND ((@IsNull_Latime = 1 AND [Latime] IS NULL) OR ([Latime] = @Original_Latime)) AND ((@IsNull_Grosime = 1 AND [Grosime] IS NULL) OR ([Grosime] = @Original_Grosime)) AND ((@IsNull_Raft = 1 AND [Raft] IS NULL) OR ([Raft] = @Original_Raft)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IDArticol" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDArticol" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_CodArticol" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CodArticol" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Denumire" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Denumire" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@Original_IDCategorie" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="IDCategorie" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@Original_CodUnitate" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="CodUnitate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@Original_IDUnitateMasura" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="IDUnitateMasura" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Cont" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Cont" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ContCheltuiala" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ContCheltuiala" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_Greutate" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="Greutate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_CotaTVA" Precision="5" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="CotaTVA" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_EsteServiciu" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="EsteServiciu" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ContVenit" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ContVenit" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ContVenit" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ContVenit" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_PretVanzare" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="PretVanzare" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ArtAl" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ArtAl" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ArtAl" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ArtAl" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_PretVanzareValuta" Precision="18" ProviderType="Decimal" Scale="4" Size="0" SourceColumn="PretVanzareValuta" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@Original_PretVanzareCodValuta" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="PretVanzareCodValuta" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_MateriePrima" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="MateriePrima" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Lungime" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Lungime" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_Lungime" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="Lungime" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Latime" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Latime" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_Latime" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="Latime" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Grosime" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Grosime" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_Grosime" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="Grosime" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Raft" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Raft" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Raft" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Raft" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [Articole] ([CodArticol], [Denumire], [IDCategorie], [CodUnitate], [IDUnitateMasura], [Cont], [ContCheltuiala], [Greutate], [CotaTVA], [EsteServiciu], [ContVenit], [PretVanzare], [ArtAl], [PretVanzareValuta], [PretVanzareCodValuta], [MateriePrima], [Lungime], [Latime], [Grosime], [Raft]) VALUES (@CodArticol, @Denumire, @IDCategorie, @CodUnitate, @IDUnitateMasura, @Cont, @ContCheltuiala, @Greutate, @CotaTVA, @EsteServiciu, @ContVenit, @PretVanzare, @ArtAl, @PretVanzareValuta, @PretVanzareCodValuta, @MateriePrima, @Lungime, @Latime, @Grosime, @Raft);
SELECT IDArticol, CodArticol, Denumire, IDCategorie, CodUnitate, IDUnitateMasura, Cont, ContCheltuiala, Greutate, CotaTVA, EsteServiciu, ContVenit, PretVanzare, ArtAl, PretVanzareValuta, PretVanzareCodValuta, MateriePrima, Lungime, Latime, Grosime, Raft FROM Articole WHERE (IDArticol = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@CodArticol" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CodArticol" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Denumire" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Denumire" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@IDCategorie" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="IDCategorie" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@CodUnitate" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="CodUnitate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@IDUnitateMasura" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="IDUnitateMasura" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Cont" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Cont" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ContCheltuiala" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ContCheltuiala" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Greutate" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="Greutate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@CotaTVA" Precision="5" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="CotaTVA" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@EsteServiciu" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="EsteServiciu" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ContVenit" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ContVenit" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@PretVanzare" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="PretVanzare" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ArtAl" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ArtAl" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@PretVanzareValuta" Precision="18" ProviderType="Decimal" Scale="4" Size="0" SourceColumn="PretVanzareValuta" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@PretVanzareCodValuta" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="PretVanzareCodValuta" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@MateriePrima" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="MateriePrima" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Lungime" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="Lungime" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Latime" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="Latime" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Grosime" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="Grosime" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Raft" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Raft" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT IDArticol, CodArticol, Denumire, IDCategorie, CodUnitate, IDUnitateMasura, Cont, ContCheltuiala, Greutate, CotaTVA, EsteServiciu, ContVenit, PretVanzare, ArtAl, PretVanzareValuta, PretVanzareCodValuta, MateriePrima, Lungime, Latime, Grosime, Raft FROM Articole</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [Articole] SET [CodArticol] = @CodArticol, [Denumire] = @Denumire, [IDCategorie] = @IDCategorie, [CodUnitate] = @CodUnitate, [IDUnitateMasura] = @IDUnitateMasura, [Cont] = @Cont, [ContCheltuiala] = @ContCheltuiala, [Greutate] = @Greutate, [CotaTVA] = @CotaTVA, [EsteServiciu] = @EsteServiciu, [ContVenit] = @ContVenit, [PretVanzare] = @PretVanzare, [ArtAl] = @ArtAl, [PretVanzareValuta] = @PretVanzareValuta, [PretVanzareCodValuta] = @PretVanzareCodValuta, [MateriePrima] = @MateriePrima, [Lungime] = @Lungime, [Latime] = @Latime, [Grosime] = @Grosime, [Raft] = @Raft WHERE (([IDArticol] = @Original_IDArticol) AND ([CodArticol] = @Original_CodArticol) AND ([Denumire] = @Original_Denumire) AND ([IDCategorie] = @Original_IDCategorie) AND ([CodUnitate] = @Original_CodUnitate) AND ([IDUnitateMasura] = @Original_IDUnitateMasura) AND ([Cont] = @Original_Cont) AND ([ContCheltuiala] = @Original_ContCheltuiala) AND ([Greutate] = @Original_Greutate) AND ([CotaTVA] = @Original_CotaTVA) AND ([EsteServiciu] = @Original_EsteServiciu) AND ((@IsNull_ContVenit = 1 AND [ContVenit] IS NULL) OR ([ContVenit] = @Original_ContVenit)) AND ([PretVanzare] = @Original_PretVanzare) AND ((@IsNull_ArtAl = 1 AND [ArtAl] IS NULL) OR ([ArtAl] = @Original_ArtAl)) AND ([PretVanzareValuta] = @Original_PretVanzareValuta) AND ([PretVanzareCodValuta] = @Original_PretVanzareCodValuta) AND ([MateriePrima] = @Original_MateriePrima) AND ((@IsNull_Lungime = 1 AND [Lungime] IS NULL) OR ([Lungime] = @Original_Lungime)) AND ((@IsNull_Latime = 1 AND [Latime] IS NULL) OR ([Latime] = @Original_Latime)) AND ((@IsNull_Grosime = 1 AND [Grosime] IS NULL) OR ([Grosime] = @Original_Grosime)) AND ((@IsNull_Raft = 1 AND [Raft] IS NULL) OR ([Raft] = @Original_Raft)));
SELECT IDArticol, CodArticol, Denumire, IDCategorie, CodUnitate, IDUnitateMasura, Cont, ContCheltuiala, Greutate, CotaTVA, EsteServiciu, ContVenit, PretVanzare, ArtAl, PretVanzareValuta, PretVanzareCodValuta, MateriePrima, Lungime, Latime, Grosime, Raft FROM Articole WHERE (IDArticol = @IDArticol)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@CodArticol" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CodArticol" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Denumire" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Denumire" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@IDCategorie" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="IDCategorie" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@CodUnitate" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="CodUnitate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@IDUnitateMasura" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="IDUnitateMasura" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Cont" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Cont" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ContCheltuiala" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ContCheltuiala" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Greutate" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="Greutate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@CotaTVA" Precision="5" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="CotaTVA" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@EsteServiciu" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="EsteServiciu" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ContVenit" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ContVenit" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@PretVanzare" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="PretVanzare" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ArtAl" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ArtAl" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@PretVanzareValuta" Precision="18" ProviderType="Decimal" Scale="4" Size="0" SourceColumn="PretVanzareValuta" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@PretVanzareCodValuta" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="PretVanzareCodValuta" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@MateriePrima" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="MateriePrima" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Lungime" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="Lungime" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Latime" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="Latime" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Grosime" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="Grosime" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Raft" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Raft" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IDArticol" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDArticol" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_CodArticol" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CodArticol" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Denumire" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Denumire" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@Original_IDCategorie" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="IDCategorie" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@Original_CodUnitate" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="CodUnitate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@Original_IDUnitateMasura" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="IDUnitateMasura" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Cont" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Cont" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ContCheltuiala" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ContCheltuiala" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_Greutate" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="Greutate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_CotaTVA" Precision="5" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="CotaTVA" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_EsteServiciu" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="EsteServiciu" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ContVenit" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ContVenit" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ContVenit" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ContVenit" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_PretVanzare" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="PretVanzare" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ArtAl" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ArtAl" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ArtAl" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ArtAl" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_PretVanzareValuta" Precision="18" ProviderType="Decimal" Scale="4" Size="0" SourceColumn="PretVanzareValuta" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@Original_PretVanzareCodValuta" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="PretVanzareCodValuta" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_MateriePrima" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="MateriePrima" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Lungime" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Lungime" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_Lungime" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="Lungime" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Latime" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Latime" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_Latime" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="Latime" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Grosime" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Grosime" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_Grosime" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="Grosime" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Raft" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Raft" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Raft" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Raft" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="IDArticol" ColumnName="IDArticol" DataSourceName="ESRP.dbo.Articole" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@IDArticol" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="IDArticol" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="IDArticol" DataSetColumn="IDArticol" />
              <Mapping SourceColumn="CodArticol" DataSetColumn="CodArticol" />
              <Mapping SourceColumn="Denumire" DataSetColumn="Denumire" />
              <Mapping SourceColumn="IDCategorie" DataSetColumn="IDCategorie" />
              <Mapping SourceColumn="CodUnitate" DataSetColumn="CodUnitate" />
              <Mapping SourceColumn="IDUnitateMasura" DataSetColumn="IDUnitateMasura" />
              <Mapping SourceColumn="Cont" DataSetColumn="Cont" />
              <Mapping SourceColumn="ContCheltuiala" DataSetColumn="ContCheltuiala" />
              <Mapping SourceColumn="Greutate" DataSetColumn="Greutate" />
              <Mapping SourceColumn="CotaTVA" DataSetColumn="CotaTVA" />
              <Mapping SourceColumn="EsteServiciu" DataSetColumn="EsteServiciu" />
              <Mapping SourceColumn="ContVenit" DataSetColumn="ContVenit" />
              <Mapping SourceColumn="PretVanzare" DataSetColumn="PretVanzare" />
              <Mapping SourceColumn="ArtAl" DataSetColumn="ArtAl" />
              <Mapping SourceColumn="PretVanzareValuta" DataSetColumn="PretVanzareValuta" />
              <Mapping SourceColumn="PretVanzareCodValuta" DataSetColumn="PretVanzareCodValuta" />
              <Mapping SourceColumn="MateriePrima" DataSetColumn="MateriePrima" />
              <Mapping SourceColumn="Lungime" DataSetColumn="Lungime" />
              <Mapping SourceColumn="Latime" DataSetColumn="Latime" />
              <Mapping SourceColumn="Grosime" DataSetColumn="Grosime" />
              <Mapping SourceColumn="Raft" DataSetColumn="Raft" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="UnitatiMasuraTableAdapter" GeneratorDataComponentClassName="UnitatiMasuraTableAdapter" Name="UnitatiMasura" UserDataComponentName="UnitatiMasuraTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ESRPConnectionString (Settings)" DbObjectName="ESRP.dbo.UnitatiMasura" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[UnitatiMasura] WHERE (([IDUnitateMasura] = @Original_IDUnitateMasura) AND ([Denumire] = @Original_Denumire) AND ([Compusa] = @Original_Compusa))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@Original_IDUnitateMasura" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="IDUnitateMasura" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Denumire" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Denumire" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_Compusa" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Compusa" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[UnitatiMasura] ([Denumire], [Compusa]) VALUES (@Denumire, @Compusa);
SELECT IDUnitateMasura, Denumire, Compusa FROM UnitatiMasura WHERE (IDUnitateMasura = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Denumire" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Denumire" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Compusa" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Compusa" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT IDUnitateMasura, Denumire, Compusa FROM dbo.UnitatiMasura</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[UnitatiMasura] SET [Denumire] = @Denumire, [Compusa] = @Compusa WHERE (([IDUnitateMasura] = @Original_IDUnitateMasura) AND ([Denumire] = @Original_Denumire) AND ([Compusa] = @Original_Compusa));
SELECT IDUnitateMasura, Denumire, Compusa FROM UnitatiMasura WHERE (IDUnitateMasura = @IDUnitateMasura)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Denumire" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Denumire" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Compusa" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Compusa" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@Original_IDUnitateMasura" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="IDUnitateMasura" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Denumire" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Denumire" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_Compusa" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Compusa" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="IDUnitateMasura" ColumnName="IDUnitateMasura" DataSourceName="ESRP.dbo.UnitatiMasura" DataTypeServer="smallint" DbType="Int16" Direction="Input" ParameterName="@IDUnitateMasura" Precision="0" ProviderType="SmallInt" Scale="0" Size="2" SourceColumn="IDUnitateMasura" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="IDUnitateMasura" DataSetColumn="IDUnitateMasura" />
              <Mapping SourceColumn="Denumire" DataSetColumn="Denumire" />
              <Mapping SourceColumn="Compusa" DataSetColumn="Compusa" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ValutaTableAdapter" GeneratorDataComponentClassName="ValutaTableAdapter" Name="Valuta" UserDataComponentName="ValutaTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ESRPConnectionString (Settings)" DbObjectName="ESRP.dbo.Valuta" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Valuta] WHERE (([CodValuta] = @Original_CodValuta) AND ([Denumire] = @Original_Denumire) AND ([Simbol] = @Original_Simbol) AND ([Utilizat] = @Original_Utilizat) AND ([MonedaImplicita] = @Original_MonedaImplicita))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@Original_CodValuta" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="CodValuta" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Denumire" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Denumire" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_Simbol" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="Simbol" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_Utilizat" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Utilizat" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_MonedaImplicita" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="MonedaImplicita" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Valuta] ([Denumire], [Simbol], [Utilizat], [MonedaImplicita]) VALUES (@Denumire, @Simbol, @Utilizat, @MonedaImplicita);
SELECT CodValuta, Denumire, Simbol, Utilizat, MonedaImplicita FROM Valuta WHERE (CodValuta = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Denumire" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Denumire" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Simbol" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="Simbol" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Utilizat" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Utilizat" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@MonedaImplicita" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="MonedaImplicita" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT CodValuta, Denumire, Simbol, Utilizat, MonedaImplicita FROM dbo.Valuta</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Valuta] SET [Denumire] = @Denumire, [Simbol] = @Simbol, [Utilizat] = @Utilizat, [MonedaImplicita] = @MonedaImplicita WHERE (([CodValuta] = @Original_CodValuta) AND ([Denumire] = @Original_Denumire) AND ([Simbol] = @Original_Simbol) AND ([Utilizat] = @Original_Utilizat) AND ([MonedaImplicita] = @Original_MonedaImplicita));
SELECT CodValuta, Denumire, Simbol, Utilizat, MonedaImplicita FROM Valuta WHERE (CodValuta = @CodValuta)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Denumire" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Denumire" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Simbol" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="Simbol" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Utilizat" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Utilizat" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@MonedaImplicita" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="MonedaImplicita" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@Original_CodValuta" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="CodValuta" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Denumire" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Denumire" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_Simbol" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="Simbol" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_Utilizat" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Utilizat" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_MonedaImplicita" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="MonedaImplicita" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="CodValuta" ColumnName="CodValuta" DataSourceName="ESRP.dbo.Valuta" DataTypeServer="smallint" DbType="Int16" Direction="Input" ParameterName="@CodValuta" Precision="0" ProviderType="SmallInt" Scale="0" Size="2" SourceColumn="CodValuta" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="CodValuta" DataSetColumn="CodValuta" />
              <Mapping SourceColumn="Denumire" DataSetColumn="Denumire" />
              <Mapping SourceColumn="Simbol" DataSetColumn="Simbol" />
              <Mapping SourceColumn="Utilizat" DataSetColumn="Utilizat" />
              <Mapping SourceColumn="MonedaImplicita" DataSetColumn="MonedaImplicita" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="FaresSetupTableAdapter" GeneratorDataComponentClassName="FaresSetupTableAdapter" Name="FaresSetup" UserDataComponentName="FaresSetupTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ESRPConnectionString (Settings)" DbObjectName="ESRP.dbo.FaresSetup" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [FaresSetup] WHERE (([PrimaryKey] = @Original_PrimaryKey) AND ([CodUnitate] = @Original_CodUnitate) AND ([FolosesteAdresa] = @Original_FolosesteAdresa) AND ([GolesteInainteImport] = @Original_GolesteInainteImport) AND ([ParteneriProprii] = @Original_ParteneriProprii) AND ([IDSerie] = @Original_IDSerie) AND ([AnCurent] = @Original_AnCurent) AND ([LunaCurenta] = @Original_LunaCurenta) AND ((@IsNull_ContArticolImplicit = 1 AND [ContArticolImplicit] IS NULL) OR ([ContArticolImplicit] = @Original_ContArticolImplicit)) AND ((@IsNull_ContCheltuialaArticolImplicit = 1 AND [ContCheltuialaArticolImplicit] IS NULL) OR ([ContCheltuialaArticolImplicit] = @Original_ContCheltuialaArticolImplicit)) AND ([CotaTVAImplicita] = @Original_CotaTVAImplicita) AND ([ComenziFaraTVA] = @Original_ComenziFaraTVA) AND ((@IsNull_AdresaLivrare1 = 1 AND [AdresaLivrare1] IS NULL) OR ([AdresaLivrare1] = @Original_AdresaLivrare1)) AND ((@IsNull_AdresaLivrare2 = 1 AND [AdresaLivrare2] IS NULL) OR ([AdresaLivrare2] = @Original_AdresaLivrare2)) AND ((@IsNull_AdresaLivrare3 = 1 AND [AdresaLivrare3] IS NULL) OR ([AdresaLivrare3] = @Original_AdresaLivrare3)) AND ([AfiseazaProprietarDocument] = @Original_AfiseazaProprietarDocument) AND ([FaraCodArticol] = @Original_FaraCodArticol) AND ([FolosesteVarinata] = @Original_FolosesteVarinata) AND ([FolosesteTermenLivrare] = @Original_FolosesteTermenLivrare) AND ([UtilizeazaDepartament] = @Original_UtilizeazaDepartament) AND ([CotaTVADetaliuDocument] = @Original_CotaTVADetaliuDocument) AND ([RegimFiscalDetaliu] = @Original_RegimFiscalDetaliu) AND ([IDSeriePlati] = @Original_IDSeriePlati) AND ([FolosesteValoareCuAdaos] = @Original_FolosesteValoareCuAdaos) AND ([SalveazaCuUrmatorulNumar] = @Original_SalveazaCuUrmatorulNumar) AND ([SalvareCuAdaugare] = @Original_SalvareCuAdaugare) AND ([FolosesteObservatii] = @Original_FolosesteObservatii) AND ((@IsNull_CaleD394 = 1 AND [CaleD394] IS NULL) OR ([CaleD394] = @Original_CaleD394)) AND ([AfiseazaDoarDocumenteleCurente] = @Original_AfiseazaDoarDocumenteleCurente) AND ((@IsNull_ContVenitArticolImplicit = 1 AND [ContVenitArticolImplicit] IS NULL) OR ([ContVenitArticolImplicit] = @Original_ContVenitArticolImplicit)) AND ([AfiseazaSemnaturiTiparire] = @Original_AfiseazaSemnaturiTiparire) AND ([IDSerieBC] = @Original_IDSerieBC) AND ([IDSerieBF] = @Original_IDSerieBF) AND ([GestiuneaStocurilor] = @Original_GestiuneaStocurilor) AND ([Valuta] = @Original_Valuta) AND ([Bugetara] = @Original_Bugetara) AND ((@IsNull_JurnalImplicit = 1 AND [JurnalImplicit] IS NULL) OR ([JurnalImplicit] = @Original_JurnalImplicit)) AND ((@IsNull_ArtAlImplicit = 1 AND [ArtAlImplicit] IS NULL) OR ([ArtAlImplicit] = @Original_ArtAlImplicit)) AND ([ValutaImplicita] = @Original_ValutaImplicita) AND ((@IsNull_FolosesteTVAArticol = 1 AND [FolosesteTVAArticol] IS NULL) OR ([FolosesteTVAArticol] = @Original_FolosesteTVAArticol)) AND ([Productie] = @Original_Productie) AND ([IDBancaImplicita] = @Original_IDBancaImplicita) AND ([ImplementareAmbalaje] = @Original_ImplementareAmbalaje) AND ([AreDocGestStoc] = @Original_AreDocGestStoc) AND ([AvizExpeditieCuTVA] = @Original_AvizExpeditieCuTVA) AND ((@IsNull_IDSerieAE = 1 AND [IDSerieAE] IS NULL) OR ([IDSerieAE] = @Original_IDSerieAE)) AND ((@IsNull_IDSerieFACT = 1 AND [IDSerieFACT] IS NULL) OR ([IDSerieFACT] = @Original_IDSerieFACT)) AND ((@IsNull_IDSerieCHIT = 1 AND [IDSerieCHIT] IS NULL) OR ([IDSerieCHIT] = @Original_IDSerieCHIT)) AND ([ComandaFaraPreturi] = @Original_ComandaFaraPreturi) AND ([DenumireNumeric1] = @Original_DenumireNumeric1) AND ([DenumireNumeric2] = @Original_DenumireNumeric2) AND ([DenumireNumeric3] = @Original_DenumireNumeric3) AND ([ProdusePePartener] = @Original_ProdusePePartener))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@Original_PrimaryKey" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="PrimaryKey" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@Original_CodUnitate" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="CodUnitate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_FolosesteAdresa" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="FolosesteAdresa" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_GolesteInainteImport" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="GolesteInainteImport" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_ParteneriProprii" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="ParteneriProprii" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_IDSerie" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="IDSerie" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@Original_AnCurent" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="AnCurent" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@Original_LunaCurenta" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="LunaCurenta" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ContArticolImplicit" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ContArticolImplicit" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ContArticolImplicit" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ContArticolImplicit" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ContCheltuialaArticolImplicit" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ContCheltuialaArticolImplicit" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ContCheltuialaArticolImplicit" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ContCheltuialaArticolImplicit" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_CotaTVAImplicita" Precision="5" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="CotaTVAImplicita" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_ComenziFaraTVA" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="ComenziFaraTVA" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_AdresaLivrare1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AdresaLivrare1" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_AdresaLivrare1" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="AdresaLivrare1" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_AdresaLivrare2" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AdresaLivrare2" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_AdresaLivrare2" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="AdresaLivrare2" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_AdresaLivrare3" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AdresaLivrare3" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_AdresaLivrare3" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="AdresaLivrare3" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_AfiseazaProprietarDocument" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="AfiseazaProprietarDocument" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_FaraCodArticol" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="FaraCodArticol" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_FolosesteVarinata" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="FolosesteVarinata" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_FolosesteTermenLivrare" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="FolosesteTermenLivrare" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_UtilizeazaDepartament" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="UtilizeazaDepartament" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_CotaTVADetaliuDocument" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="CotaTVADetaliuDocument" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_RegimFiscalDetaliu" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="RegimFiscalDetaliu" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_IDSeriePlati" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="IDSeriePlati" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_FolosesteValoareCuAdaos" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="FolosesteValoareCuAdaos" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_SalveazaCuUrmatorulNumar" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="SalveazaCuUrmatorulNumar" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_SalvareCuAdaugare" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="SalvareCuAdaugare" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_FolosesteObservatii" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="FolosesteObservatii" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CaleD394" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CaleD394" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_CaleD394" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CaleD394" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_AfiseazaDoarDocumenteleCurente" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="AfiseazaDoarDocumenteleCurente" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ContVenitArticolImplicit" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ContVenitArticolImplicit" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ContVenitArticolImplicit" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ContVenitArticolImplicit" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_AfiseazaSemnaturiTiparire" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="AfiseazaSemnaturiTiparire" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_IDSerieBC" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="IDSerieBC" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_IDSerieBF" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="IDSerieBF" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_GestiuneaStocurilor" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="GestiuneaStocurilor" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_Valuta" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Valuta" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_Bugetara" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Bugetara" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_JurnalImplicit" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="JurnalImplicit" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_JurnalImplicit" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="JurnalImplicit" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ArtAlImplicit" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ArtAlImplicit" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ArtAlImplicit" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ArtAlImplicit" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@Original_ValutaImplicita" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="ValutaImplicita" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_FolosesteTVAArticol" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FolosesteTVAArticol" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_FolosesteTVAArticol" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="FolosesteTVAArticol" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_Productie" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Productie" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@Original_IDBancaImplicita" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="IDBancaImplicita" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_ImplementareAmbalaje" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="ImplementareAmbalaje" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_AreDocGestStoc" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="AreDocGestStoc" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_AvizExpeditieCuTVA" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="AvizExpeditieCuTVA" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_IDSerieAE" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDSerieAE" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_IDSerieAE" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="IDSerieAE" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_IDSerieFACT" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDSerieFACT" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_IDSerieFACT" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="IDSerieFACT" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_IDSerieCHIT" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDSerieCHIT" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_IDSerieCHIT" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="IDSerieCHIT" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_ComandaFaraPreturi" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="ComandaFaraPreturi" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_DenumireNumeric1" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="DenumireNumeric1" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_DenumireNumeric2" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="DenumireNumeric2" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_DenumireNumeric3" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="DenumireNumeric3" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_ProdusePePartener" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="ProdusePePartener" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [FaresSetup] ([PrimaryKey], [CodUnitate], [FolosesteAdresa], [GolesteInainteImport], [ParteneriProprii], [IDSerie], [AnCurent], [LunaCurenta], [ContArticolImplicit], [ContCheltuialaArticolImplicit], [CotaTVAImplicita], [ComenziFaraTVA], [AdresaLivrare1], [AdresaLivrare2], [AdresaLivrare3], [AfiseazaProprietarDocument], [FaraCodArticol], [FolosesteVarinata], [FolosesteTermenLivrare], [UtilizeazaDepartament], [CotaTVADetaliuDocument], [RegimFiscalDetaliu], [IDSeriePlati], [FolosesteValoareCuAdaos], [SalveazaCuUrmatorulNumar], [SalvareCuAdaugare], [FolosesteObservatii], [CaleD394], [AfiseazaDoarDocumenteleCurente], [ContVenitArticolImplicit], [AfiseazaSemnaturiTiparire], [IDSerieBC], [IDSerieBF], [GestiuneaStocurilor], [Valuta], [Bugetara], [JurnalImplicit], [ArtAlImplicit], [ValutaImplicita], [FolosesteTVAArticol], [Productie], [IDBancaImplicita], [ImplementareAmbalaje], [AreDocGestStoc], [AvizExpeditieCuTVA], [IDSerieAE], [IDSerieFACT], [IDSerieCHIT], [ComandaFaraPreturi], [DenumireNumeric1], [DenumireNumeric2], [DenumireNumeric3], [ProdusePePartener]) VALUES (@PrimaryKey, @CodUnitate, @FolosesteAdresa, @GolesteInainteImport, @ParteneriProprii, @IDSerie, @AnCurent, @LunaCurenta, @ContArticolImplicit, @ContCheltuialaArticolImplicit, @CotaTVAImplicita, @ComenziFaraTVA, @AdresaLivrare1, @AdresaLivrare2, @AdresaLivrare3, @AfiseazaProprietarDocument, @FaraCodArticol, @FolosesteVarinata, @FolosesteTermenLivrare, @UtilizeazaDepartament, @CotaTVADetaliuDocument, @RegimFiscalDetaliu, @IDSeriePlati, @FolosesteValoareCuAdaos, @SalveazaCuUrmatorulNumar, @SalvareCuAdaugare, @FolosesteObservatii, @CaleD394, @AfiseazaDoarDocumenteleCurente, @ContVenitArticolImplicit, @AfiseazaSemnaturiTiparire, @IDSerieBC, @IDSerieBF, @GestiuneaStocurilor, @Valuta, @Bugetara, @JurnalImplicit, @ArtAlImplicit, @ValutaImplicita, @FolosesteTVAArticol, @Productie, @IDBancaImplicita, @ImplementareAmbalaje, @AreDocGestStoc, @AvizExpeditieCuTVA, @IDSerieAE, @IDSerieFACT, @IDSerieCHIT, @ComandaFaraPreturi, @DenumireNumeric1, @DenumireNumeric2, @DenumireNumeric3, @ProdusePePartener);
SELECT PrimaryKey, CodUnitate, FolosesteAdresa, GolesteInainteImport, ParteneriProprii, IDSerie, AnCurent, LunaCurenta, ContArticolImplicit, ContCheltuialaArticolImplicit, CotaTVAImplicita, ComenziFaraTVA, AdresaLivrare1, AdresaLivrare2, AdresaLivrare3, AfiseazaProprietarDocument, FaraCodArticol, FolosesteVarinata, FolosesteTermenLivrare, UtilizeazaDepartament, CotaTVADetaliuDocument, RegimFiscalDetaliu, IDSeriePlati, FolosesteValoareCuAdaos, SalveazaCuUrmatorulNumar, SalvareCuAdaugare, FolosesteObservatii, CaleD394, AfiseazaDoarDocumenteleCurente, ContVenitArticolImplicit, AfiseazaSemnaturiTiparire, IDSerieBC, IDSerieBF, GestiuneaStocurilor, Valuta, Bugetara, JurnalImplicit, ArtAlImplicit, ValutaImplicita, FolosesteTVAArticol, Productie, IDBancaImplicita, ImplementareAmbalaje, AreDocGestStoc, AvizExpeditieCuTVA, IDSerieAE, IDSerieFACT, IDSerieCHIT, ComandaFaraPreturi, DenumireNumeric1, DenumireNumeric2, DenumireNumeric3, ProdusePePartener FROM FaresSetup WHERE (CodUnitate = @CodUnitate) AND (PrimaryKey = @PrimaryKey)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@PrimaryKey" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="PrimaryKey" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@CodUnitate" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="CodUnitate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@FolosesteAdresa" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="FolosesteAdresa" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@GolesteInainteImport" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="GolesteInainteImport" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@ParteneriProprii" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="ParteneriProprii" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@IDSerie" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="IDSerie" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@AnCurent" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="AnCurent" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@LunaCurenta" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="LunaCurenta" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ContArticolImplicit" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ContArticolImplicit" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ContCheltuialaArticolImplicit" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ContCheltuialaArticolImplicit" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@CotaTVAImplicita" Precision="5" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="CotaTVAImplicita" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@ComenziFaraTVA" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="ComenziFaraTVA" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@AdresaLivrare1" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="AdresaLivrare1" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@AdresaLivrare2" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="AdresaLivrare2" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@AdresaLivrare3" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="AdresaLivrare3" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@AfiseazaProprietarDocument" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="AfiseazaProprietarDocument" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@FaraCodArticol" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="FaraCodArticol" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@FolosesteVarinata" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="FolosesteVarinata" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@FolosesteTermenLivrare" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="FolosesteTermenLivrare" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@UtilizeazaDepartament" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="UtilizeazaDepartament" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@CotaTVADetaliuDocument" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="CotaTVADetaliuDocument" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@RegimFiscalDetaliu" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="RegimFiscalDetaliu" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@IDSeriePlati" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="IDSeriePlati" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@FolosesteValoareCuAdaos" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="FolosesteValoareCuAdaos" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@SalveazaCuUrmatorulNumar" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="SalveazaCuUrmatorulNumar" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@SalvareCuAdaugare" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="SalvareCuAdaugare" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@FolosesteObservatii" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="FolosesteObservatii" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@CaleD394" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CaleD394" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@AfiseazaDoarDocumenteleCurente" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="AfiseazaDoarDocumenteleCurente" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ContVenitArticolImplicit" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ContVenitArticolImplicit" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@AfiseazaSemnaturiTiparire" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="AfiseazaSemnaturiTiparire" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@IDSerieBC" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="IDSerieBC" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@IDSerieBF" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="IDSerieBF" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@GestiuneaStocurilor" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="GestiuneaStocurilor" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Valuta" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Valuta" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Bugetara" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Bugetara" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@JurnalImplicit" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="JurnalImplicit" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ArtAlImplicit" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ArtAlImplicit" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@ValutaImplicita" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="ValutaImplicita" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@FolosesteTVAArticol" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="FolosesteTVAArticol" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Productie" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Productie" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@IDBancaImplicita" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="IDBancaImplicita" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@ImplementareAmbalaje" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="ImplementareAmbalaje" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@AreDocGestStoc" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="AreDocGestStoc" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@AvizExpeditieCuTVA" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="AvizExpeditieCuTVA" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@IDSerieAE" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="IDSerieAE" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@IDSerieFACT" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="IDSerieFACT" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@IDSerieCHIT" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="IDSerieCHIT" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@ComandaFaraPreturi" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="ComandaFaraPreturi" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@DenumireNumeric1" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="DenumireNumeric1" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@DenumireNumeric2" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="DenumireNumeric2" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@DenumireNumeric3" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="DenumireNumeric3" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@ProdusePePartener" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="ProdusePePartener" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT PrimaryKey, CodUnitate, FolosesteAdresa, GolesteInainteImport, ParteneriProprii, IDSerie, AnCurent, LunaCurenta, ContArticolImplicit, ContCheltuialaArticolImplicit, CotaTVAImplicita, ComenziFaraTVA, AdresaLivrare1, AdresaLivrare2, AdresaLivrare3, AfiseazaProprietarDocument, FaraCodArticol, FolosesteVarinata, FolosesteTermenLivrare, UtilizeazaDepartament, CotaTVADetaliuDocument, RegimFiscalDetaliu, IDSeriePlati, FolosesteValoareCuAdaos, SalveazaCuUrmatorulNumar, SalvareCuAdaugare, FolosesteObservatii, CaleD394, AfiseazaDoarDocumenteleCurente, ContVenitArticolImplicit, AfiseazaSemnaturiTiparire, IDSerieBC, IDSerieBF, GestiuneaStocurilor, Valuta, Bugetara, JurnalImplicit, ArtAlImplicit, ValutaImplicita, FolosesteTVAArticol, Productie, IDBancaImplicita, ImplementareAmbalaje, AreDocGestStoc, AvizExpeditieCuTVA, IDSerieAE, IDSerieFACT, IDSerieCHIT, ComandaFaraPreturi, DenumireNumeric1, DenumireNumeric2, DenumireNumeric3, ProdusePePartener FROM FaresSetup WHERE (CodUnitate = @CodUnitate)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="CodUnitate" ColumnName="CodUnitate" DataSourceName="" DataTypeServer="smallint" DbType="Int16" Direction="Input" ParameterName="@CodUnitate" Precision="0" ProviderType="SmallInt" Scale="0" Size="2" SourceColumn="CodUnitate" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [FaresSetup] SET [PrimaryKey] = @PrimaryKey, [CodUnitate] = @CodUnitate, [FolosesteAdresa] = @FolosesteAdresa, [GolesteInainteImport] = @GolesteInainteImport, [ParteneriProprii] = @ParteneriProprii, [IDSerie] = @IDSerie, [AnCurent] = @AnCurent, [LunaCurenta] = @LunaCurenta, [ContArticolImplicit] = @ContArticolImplicit, [ContCheltuialaArticolImplicit] = @ContCheltuialaArticolImplicit, [CotaTVAImplicita] = @CotaTVAImplicita, [ComenziFaraTVA] = @ComenziFaraTVA, [AdresaLivrare1] = @AdresaLivrare1, [AdresaLivrare2] = @AdresaLivrare2, [AdresaLivrare3] = @AdresaLivrare3, [AfiseazaProprietarDocument] = @AfiseazaProprietarDocument, [FaraCodArticol] = @FaraCodArticol, [FolosesteVarinata] = @FolosesteVarinata, [FolosesteTermenLivrare] = @FolosesteTermenLivrare, [UtilizeazaDepartament] = @UtilizeazaDepartament, [CotaTVADetaliuDocument] = @CotaTVADetaliuDocument, [RegimFiscalDetaliu] = @RegimFiscalDetaliu, [IDSeriePlati] = @IDSeriePlati, [FolosesteValoareCuAdaos] = @FolosesteValoareCuAdaos, [SalveazaCuUrmatorulNumar] = @SalveazaCuUrmatorulNumar, [SalvareCuAdaugare] = @SalvareCuAdaugare, [FolosesteObservatii] = @FolosesteObservatii, [CaleD394] = @CaleD394, [AfiseazaDoarDocumenteleCurente] = @AfiseazaDoarDocumenteleCurente, [ContVenitArticolImplicit] = @ContVenitArticolImplicit, [AfiseazaSemnaturiTiparire] = @AfiseazaSemnaturiTiparire, [IDSerieBC] = @IDSerieBC, [IDSerieBF] = @IDSerieBF, [GestiuneaStocurilor] = @GestiuneaStocurilor, [Valuta] = @Valuta, [Bugetara] = @Bugetara, [JurnalImplicit] = @JurnalImplicit, [ArtAlImplicit] = @ArtAlImplicit, [ValutaImplicita] = @ValutaImplicita, [FolosesteTVAArticol] = @FolosesteTVAArticol, [Productie] = @Productie, [IDBancaImplicita] = @IDBancaImplicita, [ImplementareAmbalaje] = @ImplementareAmbalaje, [AreDocGestStoc] = @AreDocGestStoc, [AvizExpeditieCuTVA] = @AvizExpeditieCuTVA, [IDSerieAE] = @IDSerieAE, [IDSerieFACT] = @IDSerieFACT, [IDSerieCHIT] = @IDSerieCHIT, [ComandaFaraPreturi] = @ComandaFaraPreturi, [DenumireNumeric1] = @DenumireNumeric1, [DenumireNumeric2] = @DenumireNumeric2, [DenumireNumeric3] = @DenumireNumeric3, [ProdusePePartener] = @ProdusePePartener WHERE (([PrimaryKey] = @Original_PrimaryKey) AND ([CodUnitate] = @Original_CodUnitate) AND ([FolosesteAdresa] = @Original_FolosesteAdresa) AND ([GolesteInainteImport] = @Original_GolesteInainteImport) AND ([ParteneriProprii] = @Original_ParteneriProprii) AND ([IDSerie] = @Original_IDSerie) AND ([AnCurent] = @Original_AnCurent) AND ([LunaCurenta] = @Original_LunaCurenta) AND ((@IsNull_ContArticolImplicit = 1 AND [ContArticolImplicit] IS NULL) OR ([ContArticolImplicit] = @Original_ContArticolImplicit)) AND ((@IsNull_ContCheltuialaArticolImplicit = 1 AND [ContCheltuialaArticolImplicit] IS NULL) OR ([ContCheltuialaArticolImplicit] = @Original_ContCheltuialaArticolImplicit)) AND ([CotaTVAImplicita] = @Original_CotaTVAImplicita) AND ([ComenziFaraTVA] = @Original_ComenziFaraTVA) AND ((@IsNull_AdresaLivrare1 = 1 AND [AdresaLivrare1] IS NULL) OR ([AdresaLivrare1] = @Original_AdresaLivrare1)) AND ((@IsNull_AdresaLivrare2 = 1 AND [AdresaLivrare2] IS NULL) OR ([AdresaLivrare2] = @Original_AdresaLivrare2)) AND ((@IsNull_AdresaLivrare3 = 1 AND [AdresaLivrare3] IS NULL) OR ([AdresaLivrare3] = @Original_AdresaLivrare3)) AND ([AfiseazaProprietarDocument] = @Original_AfiseazaProprietarDocument) AND ([FaraCodArticol] = @Original_FaraCodArticol) AND ([FolosesteVarinata] = @Original_FolosesteVarinata) AND ([FolosesteTermenLivrare] = @Original_FolosesteTermenLivrare) AND ([UtilizeazaDepartament] = @Original_UtilizeazaDepartament) AND ([CotaTVADetaliuDocument] = @Original_CotaTVADetaliuDocument) AND ([RegimFiscalDetaliu] = @Original_RegimFiscalDetaliu) AND ([IDSeriePlati] = @Original_IDSeriePlati) AND ([FolosesteValoareCuAdaos] = @Original_FolosesteValoareCuAdaos) AND ([SalveazaCuUrmatorulNumar] = @Original_SalveazaCuUrmatorulNumar) AND ([SalvareCuAdaugare] = @Original_SalvareCuAdaugare) AND ([FolosesteObservatii] = @Original_FolosesteObservatii) AND ((@IsNull_CaleD394 = 1 AND [CaleD394] IS NULL) OR ([CaleD394] = @Original_CaleD394)) AND ([AfiseazaDoarDocumenteleCurente] = @Original_AfiseazaDoarDocumenteleCurente) AND ((@IsNull_ContVenitArticolImplicit = 1 AND [ContVenitArticolImplicit] IS NULL) OR ([ContVenitArticolImplicit] = @Original_ContVenitArticolImplicit)) AND ([AfiseazaSemnaturiTiparire] = @Original_AfiseazaSemnaturiTiparire) AND ([IDSerieBC] = @Original_IDSerieBC) AND ([IDSerieBF] = @Original_IDSerieBF) AND ([GestiuneaStocurilor] = @Original_GestiuneaStocurilor) AND ([Valuta] = @Original_Valuta) AND ([Bugetara] = @Original_Bugetara) AND ((@IsNull_JurnalImplicit = 1 AND [JurnalImplicit] IS NULL) OR ([JurnalImplicit] = @Original_JurnalImplicit)) AND ((@IsNull_ArtAlImplicit = 1 AND [ArtAlImplicit] IS NULL) OR ([ArtAlImplicit] = @Original_ArtAlImplicit)) AND ([ValutaImplicita] = @Original_ValutaImplicita) AND ((@IsNull_FolosesteTVAArticol = 1 AND [FolosesteTVAArticol] IS NULL) OR ([FolosesteTVAArticol] = @Original_FolosesteTVAArticol)) AND ([Productie] = @Original_Productie) AND ([IDBancaImplicita] = @Original_IDBancaImplicita) AND ([ImplementareAmbalaje] = @Original_ImplementareAmbalaje) AND ([AreDocGestStoc] = @Original_AreDocGestStoc) AND ([AvizExpeditieCuTVA] = @Original_AvizExpeditieCuTVA) AND ((@IsNull_IDSerieAE = 1 AND [IDSerieAE] IS NULL) OR ([IDSerieAE] = @Original_IDSerieAE)) AND ((@IsNull_IDSerieFACT = 1 AND [IDSerieFACT] IS NULL) OR ([IDSerieFACT] = @Original_IDSerieFACT)) AND ((@IsNull_IDSerieCHIT = 1 AND [IDSerieCHIT] IS NULL) OR ([IDSerieCHIT] = @Original_IDSerieCHIT)) AND ([ComandaFaraPreturi] = @Original_ComandaFaraPreturi) AND ([DenumireNumeric1] = @Original_DenumireNumeric1) AND ([DenumireNumeric2] = @Original_DenumireNumeric2) AND ([DenumireNumeric3] = @Original_DenumireNumeric3) AND ([ProdusePePartener] = @Original_ProdusePePartener));
SELECT PrimaryKey, CodUnitate, FolosesteAdresa, GolesteInainteImport, ParteneriProprii, IDSerie, AnCurent, LunaCurenta, ContArticolImplicit, ContCheltuialaArticolImplicit, CotaTVAImplicita, ComenziFaraTVA, AdresaLivrare1, AdresaLivrare2, AdresaLivrare3, AfiseazaProprietarDocument, FaraCodArticol, FolosesteVarinata, FolosesteTermenLivrare, UtilizeazaDepartament, CotaTVADetaliuDocument, RegimFiscalDetaliu, IDSeriePlati, FolosesteValoareCuAdaos, SalveazaCuUrmatorulNumar, SalvareCuAdaugare, FolosesteObservatii, CaleD394, AfiseazaDoarDocumenteleCurente, ContVenitArticolImplicit, AfiseazaSemnaturiTiparire, IDSerieBC, IDSerieBF, GestiuneaStocurilor, Valuta, Bugetara, JurnalImplicit, ArtAlImplicit, ValutaImplicita, FolosesteTVAArticol, Productie, IDBancaImplicita, ImplementareAmbalaje, AreDocGestStoc, AvizExpeditieCuTVA, IDSerieAE, IDSerieFACT, IDSerieCHIT, ComandaFaraPreturi, DenumireNumeric1, DenumireNumeric2, DenumireNumeric3, ProdusePePartener FROM FaresSetup WHERE (CodUnitate = @CodUnitate) AND (PrimaryKey = @PrimaryKey)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@PrimaryKey" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="PrimaryKey" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@CodUnitate" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="CodUnitate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@FolosesteAdresa" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="FolosesteAdresa" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@GolesteInainteImport" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="GolesteInainteImport" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@ParteneriProprii" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="ParteneriProprii" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@IDSerie" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="IDSerie" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@AnCurent" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="AnCurent" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@LunaCurenta" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="LunaCurenta" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ContArticolImplicit" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ContArticolImplicit" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ContCheltuialaArticolImplicit" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ContCheltuialaArticolImplicit" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@CotaTVAImplicita" Precision="5" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="CotaTVAImplicita" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@ComenziFaraTVA" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="ComenziFaraTVA" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@AdresaLivrare1" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="AdresaLivrare1" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@AdresaLivrare2" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="AdresaLivrare2" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@AdresaLivrare3" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="AdresaLivrare3" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@AfiseazaProprietarDocument" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="AfiseazaProprietarDocument" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@FaraCodArticol" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="FaraCodArticol" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@FolosesteVarinata" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="FolosesteVarinata" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@FolosesteTermenLivrare" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="FolosesteTermenLivrare" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@UtilizeazaDepartament" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="UtilizeazaDepartament" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@CotaTVADetaliuDocument" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="CotaTVADetaliuDocument" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@RegimFiscalDetaliu" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="RegimFiscalDetaliu" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@IDSeriePlati" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="IDSeriePlati" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@FolosesteValoareCuAdaos" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="FolosesteValoareCuAdaos" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@SalveazaCuUrmatorulNumar" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="SalveazaCuUrmatorulNumar" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@SalvareCuAdaugare" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="SalvareCuAdaugare" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@FolosesteObservatii" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="FolosesteObservatii" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@CaleD394" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CaleD394" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@AfiseazaDoarDocumenteleCurente" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="AfiseazaDoarDocumenteleCurente" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ContVenitArticolImplicit" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ContVenitArticolImplicit" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@AfiseazaSemnaturiTiparire" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="AfiseazaSemnaturiTiparire" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@IDSerieBC" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="IDSerieBC" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@IDSerieBF" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="IDSerieBF" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@GestiuneaStocurilor" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="GestiuneaStocurilor" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Valuta" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Valuta" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Bugetara" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Bugetara" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@JurnalImplicit" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="JurnalImplicit" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ArtAlImplicit" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ArtAlImplicit" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@ValutaImplicita" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="ValutaImplicita" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@FolosesteTVAArticol" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="FolosesteTVAArticol" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Productie" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Productie" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@IDBancaImplicita" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="IDBancaImplicita" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@ImplementareAmbalaje" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="ImplementareAmbalaje" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@AreDocGestStoc" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="AreDocGestStoc" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@AvizExpeditieCuTVA" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="AvizExpeditieCuTVA" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@IDSerieAE" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="IDSerieAE" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@IDSerieFACT" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="IDSerieFACT" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@IDSerieCHIT" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="IDSerieCHIT" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@ComandaFaraPreturi" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="ComandaFaraPreturi" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@DenumireNumeric1" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="DenumireNumeric1" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@DenumireNumeric2" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="DenumireNumeric2" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@DenumireNumeric3" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="DenumireNumeric3" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@ProdusePePartener" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="ProdusePePartener" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@Original_PrimaryKey" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="PrimaryKey" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@Original_CodUnitate" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="CodUnitate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_FolosesteAdresa" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="FolosesteAdresa" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_GolesteInainteImport" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="GolesteInainteImport" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_ParteneriProprii" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="ParteneriProprii" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_IDSerie" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="IDSerie" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@Original_AnCurent" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="AnCurent" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@Original_LunaCurenta" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="LunaCurenta" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ContArticolImplicit" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ContArticolImplicit" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ContArticolImplicit" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ContArticolImplicit" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ContCheltuialaArticolImplicit" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ContCheltuialaArticolImplicit" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ContCheltuialaArticolImplicit" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ContCheltuialaArticolImplicit" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_CotaTVAImplicita" Precision="5" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="CotaTVAImplicita" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_ComenziFaraTVA" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="ComenziFaraTVA" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_AdresaLivrare1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AdresaLivrare1" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_AdresaLivrare1" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="AdresaLivrare1" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_AdresaLivrare2" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AdresaLivrare2" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_AdresaLivrare2" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="AdresaLivrare2" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_AdresaLivrare3" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AdresaLivrare3" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_AdresaLivrare3" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="AdresaLivrare3" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_AfiseazaProprietarDocument" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="AfiseazaProprietarDocument" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_FaraCodArticol" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="FaraCodArticol" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_FolosesteVarinata" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="FolosesteVarinata" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_FolosesteTermenLivrare" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="FolosesteTermenLivrare" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_UtilizeazaDepartament" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="UtilizeazaDepartament" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_CotaTVADetaliuDocument" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="CotaTVADetaliuDocument" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_RegimFiscalDetaliu" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="RegimFiscalDetaliu" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_IDSeriePlati" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="IDSeriePlati" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_FolosesteValoareCuAdaos" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="FolosesteValoareCuAdaos" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_SalveazaCuUrmatorulNumar" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="SalveazaCuUrmatorulNumar" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_SalvareCuAdaugare" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="SalvareCuAdaugare" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_FolosesteObservatii" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="FolosesteObservatii" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CaleD394" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CaleD394" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_CaleD394" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CaleD394" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_AfiseazaDoarDocumenteleCurente" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="AfiseazaDoarDocumenteleCurente" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ContVenitArticolImplicit" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ContVenitArticolImplicit" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ContVenitArticolImplicit" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ContVenitArticolImplicit" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_AfiseazaSemnaturiTiparire" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="AfiseazaSemnaturiTiparire" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_IDSerieBC" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="IDSerieBC" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_IDSerieBF" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="IDSerieBF" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_GestiuneaStocurilor" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="GestiuneaStocurilor" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_Valuta" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Valuta" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_Bugetara" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Bugetara" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_JurnalImplicit" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="JurnalImplicit" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_JurnalImplicit" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="JurnalImplicit" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ArtAlImplicit" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ArtAlImplicit" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ArtAlImplicit" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ArtAlImplicit" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@Original_ValutaImplicita" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="ValutaImplicita" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_FolosesteTVAArticol" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FolosesteTVAArticol" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_FolosesteTVAArticol" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="FolosesteTVAArticol" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_Productie" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Productie" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@Original_IDBancaImplicita" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="IDBancaImplicita" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_ImplementareAmbalaje" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="ImplementareAmbalaje" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_AreDocGestStoc" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="AreDocGestStoc" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_AvizExpeditieCuTVA" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="AvizExpeditieCuTVA" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_IDSerieAE" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDSerieAE" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_IDSerieAE" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="IDSerieAE" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_IDSerieFACT" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDSerieFACT" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_IDSerieFACT" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="IDSerieFACT" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_IDSerieCHIT" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDSerieCHIT" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_IDSerieCHIT" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="IDSerieCHIT" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_ComandaFaraPreturi" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="ComandaFaraPreturi" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_DenumireNumeric1" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="DenumireNumeric1" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_DenumireNumeric2" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="DenumireNumeric2" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_DenumireNumeric3" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="DenumireNumeric3" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_ProdusePePartener" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="ProdusePePartener" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="PrimaryKey" DataSetColumn="PrimaryKey" />
              <Mapping SourceColumn="CodUnitate" DataSetColumn="CodUnitate" />
              <Mapping SourceColumn="FolosesteAdresa" DataSetColumn="FolosesteAdresa" />
              <Mapping SourceColumn="GolesteInainteImport" DataSetColumn="GolesteInainteImport" />
              <Mapping SourceColumn="ParteneriProprii" DataSetColumn="ParteneriProprii" />
              <Mapping SourceColumn="IDSerie" DataSetColumn="IDSerie" />
              <Mapping SourceColumn="AnCurent" DataSetColumn="AnCurent" />
              <Mapping SourceColumn="LunaCurenta" DataSetColumn="LunaCurenta" />
              <Mapping SourceColumn="ContArticolImplicit" DataSetColumn="ContArticolImplicit" />
              <Mapping SourceColumn="ContCheltuialaArticolImplicit" DataSetColumn="ContCheltuialaArticolImplicit" />
              <Mapping SourceColumn="CotaTVAImplicita" DataSetColumn="CotaTVAImplicita" />
              <Mapping SourceColumn="ComenziFaraTVA" DataSetColumn="ComenziFaraTVA" />
              <Mapping SourceColumn="AdresaLivrare1" DataSetColumn="AdresaLivrare1" />
              <Mapping SourceColumn="AdresaLivrare2" DataSetColumn="AdresaLivrare2" />
              <Mapping SourceColumn="AdresaLivrare3" DataSetColumn="AdresaLivrare3" />
              <Mapping SourceColumn="AfiseazaProprietarDocument" DataSetColumn="AfiseazaProprietarDocument" />
              <Mapping SourceColumn="FaraCodArticol" DataSetColumn="FaraCodArticol" />
              <Mapping SourceColumn="FolosesteVarinata" DataSetColumn="FolosesteVarinata" />
              <Mapping SourceColumn="FolosesteTermenLivrare" DataSetColumn="FolosesteTermenLivrare" />
              <Mapping SourceColumn="UtilizeazaDepartament" DataSetColumn="UtilizeazaDepartament" />
              <Mapping SourceColumn="CotaTVADetaliuDocument" DataSetColumn="CotaTVADetaliuDocument" />
              <Mapping SourceColumn="RegimFiscalDetaliu" DataSetColumn="RegimFiscalDetaliu" />
              <Mapping SourceColumn="IDSeriePlati" DataSetColumn="IDSeriePlati" />
              <Mapping SourceColumn="FolosesteValoareCuAdaos" DataSetColumn="FolosesteValoareCuAdaos" />
              <Mapping SourceColumn="SalveazaCuUrmatorulNumar" DataSetColumn="SalveazaCuUrmatorulNumar" />
              <Mapping SourceColumn="SalvareCuAdaugare" DataSetColumn="SalvareCuAdaugare" />
              <Mapping SourceColumn="FolosesteObservatii" DataSetColumn="FolosesteObservatii" />
              <Mapping SourceColumn="CaleD394" DataSetColumn="CaleD394" />
              <Mapping SourceColumn="AfiseazaDoarDocumenteleCurente" DataSetColumn="AfiseazaDoarDocumenteleCurente" />
              <Mapping SourceColumn="ContVenitArticolImplicit" DataSetColumn="ContVenitArticolImplicit" />
              <Mapping SourceColumn="AfiseazaSemnaturiTiparire" DataSetColumn="AfiseazaSemnaturiTiparire" />
              <Mapping SourceColumn="IDSerieBC" DataSetColumn="IDSerieBC" />
              <Mapping SourceColumn="IDSerieBF" DataSetColumn="IDSerieBF" />
              <Mapping SourceColumn="GestiuneaStocurilor" DataSetColumn="GestiuneaStocurilor" />
              <Mapping SourceColumn="Valuta" DataSetColumn="Valuta" />
              <Mapping SourceColumn="Bugetara" DataSetColumn="Bugetara" />
              <Mapping SourceColumn="JurnalImplicit" DataSetColumn="JurnalImplicit" />
              <Mapping SourceColumn="ArtAlImplicit" DataSetColumn="ArtAlImplicit" />
              <Mapping SourceColumn="ValutaImplicita" DataSetColumn="ValutaImplicita" />
              <Mapping SourceColumn="FolosesteTVAArticol" DataSetColumn="FolosesteTVAArticol" />
              <Mapping SourceColumn="Productie" DataSetColumn="Productie" />
              <Mapping SourceColumn="IDBancaImplicita" DataSetColumn="IDBancaImplicita" />
              <Mapping SourceColumn="ImplementareAmbalaje" DataSetColumn="ImplementareAmbalaje" />
              <Mapping SourceColumn="AreDocGestStoc" DataSetColumn="AreDocGestStoc" />
              <Mapping SourceColumn="AvizExpeditieCuTVA" DataSetColumn="AvizExpeditieCuTVA" />
              <Mapping SourceColumn="IDSerieAE" DataSetColumn="IDSerieAE" />
              <Mapping SourceColumn="IDSerieFACT" DataSetColumn="IDSerieFACT" />
              <Mapping SourceColumn="IDSerieCHIT" DataSetColumn="IDSerieCHIT" />
              <Mapping SourceColumn="ComandaFaraPreturi" DataSetColumn="ComandaFaraPreturi" />
              <Mapping SourceColumn="ProdusePePartener" DataSetColumn="ProdusePePartener" />
              <Mapping SourceColumn="DenumireNumeric1" DataSetColumn="DenumireNumeric1" />
              <Mapping SourceColumn="DenumireNumeric2" DataSetColumn="DenumireNumeric2" />
              <Mapping SourceColumn="DenumireNumeric3" DataSetColumn="DenumireNumeric3" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="DocumenteDetaliuLinkTableAdapter" GeneratorDataComponentClassName="DocumenteDetaliuLinkTableAdapter" Name="DocumenteDetaliuLink" UserDataComponentName="DocumenteDetaliuLinkTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ESRPConnectionString (Settings)" DbObjectName="ESRP.dbo.DocumenteDetaliuLink" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Fill" GenerateShortCommands="true" GeneratorSourceName="Fill" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [DocumenteDetaliuLink] WHERE (([IDDocDetaliuLink] = @Original_IDDocDetaliuLink) AND ([IDDocDetaliuSursa] = @Original_IDDocDetaliuSursa) AND ([IDDocDetaliuDest] = @Original_IDDocDetaliuDest) AND ((@IsNull_Cantitate = 1 AND [Cantitate] IS NULL) OR ([Cantitate] = @Original_Cantitate)) AND ([Tip] = @Original_Tip))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_IDDocDetaliuLink" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="IDDocDetaliuLink" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_IDDocDetaliuSursa" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="IDDocDetaliuSursa" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_IDDocDetaliuDest" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="IDDocDetaliuDest" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Cantitate" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Cantitate" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_Cantitate" Precision="25" ProviderType="Decimal" Scale="5" Size="0" SourceColumn="Cantitate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_Tip" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="Tip" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [DocumenteDetaliuLink] ([IDDocDetaliuSursa], [IDDocDetaliuDest], [Cantitate], [Tip]) VALUES (@IDDocDetaliuSursa, @IDDocDetaliuDest, @Cantitate, @Tip);
SELECT IDDocDetaliuLink, IDDocDetaliuSursa, IDDocDetaliuDest, Cantitate, Tip FROM DocumenteDetaliuLink WHERE (IDDocDetaliuLink = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@IDDocDetaliuSursa" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="IDDocDetaliuSursa" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@IDDocDetaliuDest" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="IDDocDetaliuDest" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Cantitate" Precision="25" ProviderType="Decimal" Scale="5" Size="0" SourceColumn="Cantitate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Tip" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="Tip" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT IDDocDetaliuLink, IDDocDetaliuSursa, IDDocDetaliuDest, Cantitate, Tip FROM DocumenteDetaliuLink</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [DocumenteDetaliuLink] SET [IDDocDetaliuSursa] = @IDDocDetaliuSursa, [IDDocDetaliuDest] = @IDDocDetaliuDest, [Cantitate] = @Cantitate, [Tip] = @Tip WHERE (([IDDocDetaliuLink] = @Original_IDDocDetaliuLink) AND ([IDDocDetaliuSursa] = @Original_IDDocDetaliuSursa) AND ([IDDocDetaliuDest] = @Original_IDDocDetaliuDest) AND ((@IsNull_Cantitate = 1 AND [Cantitate] IS NULL) OR ([Cantitate] = @Original_Cantitate)) AND ([Tip] = @Original_Tip));
SELECT IDDocDetaliuLink, IDDocDetaliuSursa, IDDocDetaliuDest, Cantitate, Tip FROM DocumenteDetaliuLink WHERE (IDDocDetaliuLink = @IDDocDetaliuLink)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@IDDocDetaliuSursa" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="IDDocDetaliuSursa" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@IDDocDetaliuDest" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="IDDocDetaliuDest" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Cantitate" Precision="25" ProviderType="Decimal" Scale="5" Size="0" SourceColumn="Cantitate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Tip" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="Tip" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_IDDocDetaliuLink" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="IDDocDetaliuLink" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_IDDocDetaliuSursa" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="IDDocDetaliuSursa" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_IDDocDetaliuDest" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="IDDocDetaliuDest" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Cantitate" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Cantitate" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_Cantitate" Precision="25" ProviderType="Decimal" Scale="5" Size="0" SourceColumn="Cantitate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_Tip" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="Tip" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="IDDocDetaliuLink" ColumnName="IDDocDetaliuLink" DataSourceName="ESRP.dbo.DocumenteDetaliuLink" DataTypeServer="bigint" DbType="Int64" Direction="Input" ParameterName="@IDDocDetaliuLink" Precision="0" ProviderType="BigInt" Scale="0" Size="8" SourceColumn="IDDocDetaliuLink" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="IDDocDetaliuLink" DataSetColumn="IDDocDetaliuLink" />
              <Mapping SourceColumn="IDDocDetaliuSursa" DataSetColumn="IDDocDetaliuSursa" />
              <Mapping SourceColumn="IDDocDetaliuDest" DataSetColumn="IDDocDetaliuDest" />
              <Mapping SourceColumn="Cantitate" DataSetColumn="Cantitate" />
              <Mapping SourceColumn="Tip" DataSetColumn="Tip" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="ESRPConnectionString (Settings)" DbObjectName="ESRP.dbo.DocumenteDetaliuLink" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByDest" GenerateMethods="Fill" GenerateShortCommands="true" GeneratorSourceName="FillByDest" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="FillByDest">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT IDDocDetaliuLink, IDDocDetaliuSursa, IDDocDetaliuDest, Cantitate, Tip FROM DocumenteDetaliuLink WHERE (IDDocDetaliuDest = @IDDocDetaliuDest) AND Tip=@Tip</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="IDDocDetaliuDest" ColumnName="IDDocDetaliuDest" DataSourceName="ESRP.dbo.DocumenteDetaliuLink" DataTypeServer="bigint" DbType="Int64" Direction="Input" ParameterName="@IDDocDetaliuDest" Precision="0" ProviderType="BigInt" Scale="0" Size="8" SourceColumn="IDDocDetaliuDest" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="Tip" ColumnName="Tip" DataSourceName="ESRP.dbo.DocumenteDetaliuLink" DataTypeServer="char(2)" DbType="AnsiString" Direction="Input" ParameterName="@Tip" Precision="0" ProviderType="Char" Scale="0" Size="2" SourceColumn="Tip" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="TipDocumentTableAdapter" GeneratorDataComponentClassName="TipDocumentTableAdapter" Name="TipDocument" UserDataComponentName="TipDocumentTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ESRPConnectionString (Settings)" DbObjectName="ESRP.dbo.TipDocument" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[TipDocument] WHERE (([IDTipDocument] = @Original_IDTipDocument) AND ([Denumire] = @Original_Denumire) AND ([TipOperatie] = @Original_TipOperatie) AND ([SePlateste] = @Original_SePlateste) AND ([ModificaStoc] = @Original_ModificaStoc))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@Original_IDTipDocument" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="IDTipDocument" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Denumire" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Denumire" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_TipOperatie" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="TipOperatie" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_SePlateste" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="SePlateste" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_ModificaStoc" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="ModificaStoc" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[TipDocument] ([Denumire], [TipOperatie], [SePlateste], [ModificaStoc]) VALUES (@Denumire, @TipOperatie, @SePlateste, @ModificaStoc);
SELECT IDTipDocument, Denumire, TipOperatie, SePlateste, ModificaStoc FROM TipDocument WHERE (IDTipDocument = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Denumire" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Denumire" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@TipOperatie" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="TipOperatie" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@SePlateste" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="SePlateste" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@ModificaStoc" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="ModificaStoc" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT IDTipDocument, Denumire, TipOperatie, SePlateste, ModificaStoc FROM dbo.TipDocument</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[TipDocument] SET [Denumire] = @Denumire, [TipOperatie] = @TipOperatie, [SePlateste] = @SePlateste, [ModificaStoc] = @ModificaStoc WHERE (([IDTipDocument] = @Original_IDTipDocument) AND ([Denumire] = @Original_Denumire) AND ([TipOperatie] = @Original_TipOperatie) AND ([SePlateste] = @Original_SePlateste) AND ([ModificaStoc] = @Original_ModificaStoc));
SELECT IDTipDocument, Denumire, TipOperatie, SePlateste, ModificaStoc FROM TipDocument WHERE (IDTipDocument = @IDTipDocument)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Denumire" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Denumire" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@TipOperatie" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="TipOperatie" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@SePlateste" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="SePlateste" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@ModificaStoc" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="ModificaStoc" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@Original_IDTipDocument" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="IDTipDocument" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Denumire" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Denumire" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_TipOperatie" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="TipOperatie" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_SePlateste" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="SePlateste" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_ModificaStoc" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="ModificaStoc" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="IDTipDocument" ColumnName="IDTipDocument" DataSourceName="ESRP.dbo.TipDocument" DataTypeServer="smallint" DbType="Int16" Direction="Input" ParameterName="@IDTipDocument" Precision="0" ProviderType="SmallInt" Scale="0" Size="2" SourceColumn="IDTipDocument" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="IDTipDocument" DataSetColumn="IDTipDocument" />
              <Mapping SourceColumn="Denumire" DataSetColumn="Denumire" />
              <Mapping SourceColumn="TipOperatie" DataSetColumn="TipOperatie" />
              <Mapping SourceColumn="SePlateste" DataSetColumn="SePlateste" />
              <Mapping SourceColumn="ModificaStoc" DataSetColumn="ModificaStoc" />
            </Mappings>
            <Sources />
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="ESRPDataSetComenziNeonorate" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="True" msprop:Generator_DataSetName="ESRPDataSetComenziNeonorate" msprop:Generator_UserDSName="ESRPDataSetComenziNeonorate">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="fares_viewComenziNeonorate" msprop:Generator_TableClassName="fares_viewComenziNeonorateDataTable" msprop:Generator_TableVarName="tablefares_viewComenziNeonorate" msprop:Generator_TablePropName="fares_viewComenziNeonorate" msprop:Generator_RowDeletingName="fares_viewComenziNeonorateRowDeleting" msprop:Generator_RowChangingName="fares_viewComenziNeonorateRowChanging" msprop:Generator_RowEvHandlerName="fares_viewComenziNeonorateRowChangeEventHandler" msprop:Generator_RowDeletedName="fares_viewComenziNeonorateRowDeleted" msprop:Generator_UserTableName="fares_viewComenziNeonorate" msprop:Generator_RowChangedName="fares_viewComenziNeonorateRowChanged" msprop:Generator_RowEvArgName="fares_viewComenziNeonorateRowChangeEvent" msprop:Generator_RowClassName="fares_viewComenziNeonorateRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="IDDocumentDetaliu" msprop:Generator_ColumnVarNameInTable="columnIDDocumentDetaliu" msprop:Generator_ColumnPropNameInRow="IDDocumentDetaliu" msprop:Generator_ColumnPropNameInTable="IDDocumentDetaliuColumn" msprop:Generator_UserColumnName="IDDocumentDetaliu" type="xs:long" />
              <xs:element name="IDArticol" msprop:Generator_ColumnVarNameInTable="columnIDArticol" msprop:Generator_ColumnPropNameInRow="IDArticol" msprop:Generator_ColumnPropNameInTable="IDArticolColumn" msprop:Generator_UserColumnName="IDArticol" type="xs:int" />
              <xs:element name="Cantitate" msprop:Generator_ColumnVarNameInTable="columnCantitate" msprop:Generator_ColumnPropNameInRow="Cantitate" msprop:Generator_ColumnPropNameInTable="CantitateColumn" msprop:Generator_UserColumnName="Cantitate" type="xs:decimal" />
              <xs:element name="ValoareUnitara" msprop:Generator_ColumnVarNameInTable="columnValoareUnitara" msprop:Generator_ColumnPropNameInRow="ValoareUnitara" msprop:Generator_ColumnPropNameInTable="ValoareUnitaraColumn" msprop:Generator_UserColumnName="ValoareUnitara" type="xs:decimal" />
              <xs:element name="IDUnitateMasura" msprop:Generator_ColumnVarNameInTable="columnIDUnitateMasura" msprop:Generator_ColumnPropNameInRow="IDUnitateMasura" msprop:Generator_ColumnPropNameInTable="IDUnitateMasuraColumn" msprop:Generator_UserColumnName="IDUnitateMasura" type="xs:short" />
              <xs:element name="TermenLivrare" msprop:Generator_ColumnVarNameInTable="columnTermenLivrare" msprop:Generator_ColumnPropNameInRow="TermenLivrare" msprop:Generator_ColumnPropNameInTable="TermenLivrareColumn" msprop:Generator_UserColumnName="TermenLivrare" type="xs:dateTime" minOccurs="0" />
              <xs:element name="Observatii" msprop:Generator_ColumnVarNameInTable="columnObservatii" msprop:Generator_ColumnPropNameInRow="Observatii" msprop:Generator_ColumnPropNameInTable="ObservatiiColumn" msprop:Generator_UserColumnName="Observatii" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="250" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ValoareUnitaraValuta" msprop:Generator_ColumnVarNameInTable="columnValoareUnitaraValuta" msprop:Generator_ColumnPropNameInRow="ValoareUnitaraValuta" msprop:Generator_ColumnPropNameInTable="ValoareUnitaraValutaColumn" msprop:Generator_UserColumnName="ValoareUnitaraValuta" type="xs:decimal" />
              <xs:element name="NrDoc" msprop:Generator_ColumnVarNameInTable="columnNrDoc" msprop:Generator_ColumnPropNameInRow="NrDoc" msprop:Generator_ColumnPropNameInTable="NrDocColumn" msprop:Generator_UserColumnName="NrDoc">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DataDoc" msprop:Generator_ColumnVarNameInTable="columnDataDoc" msprop:Generator_ColumnPropNameInRow="DataDoc" msprop:Generator_ColumnPropNameInTable="DataDocColumn" msprop:Generator_UserColumnName="DataDoc" type="xs:dateTime" />
              <xs:element name="CodValuta" msprop:Generator_ColumnVarNameInTable="columnCodValuta" msprop:Generator_ColumnPropNameInRow="CodValuta" msprop:Generator_ColumnPropNameInTable="CodValutaColumn" msprop:Generator_UserColumnName="CodValuta" type="xs:short" />
              <xs:element name="CantitateReceptionata" msprop:Generator_ColumnVarNameInTable="columnCantitateReceptionata" msprop:Generator_ColumnPropNameInRow="CantitateReceptionata" msprop:Generator_ColumnPropNameInTable="CantitateReceptionataColumn" msprop:Generator_UserColumnName="CantitateReceptionata" type="xs:decimal" minOccurs="0" />
              <xs:element name="CantitateRamasa" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnCantitateRamasa" msprop:Generator_ColumnPropNameInRow="CantitateRamasa" msprop:Generator_ColumnPropNameInTable="CantitateRamasaColumn" msprop:Generator_UserColumnName="CantitateRamasa" type="xs:decimal" minOccurs="0" />
              <xs:element name="CodUnitate" msprop:Generator_ColumnVarNameInTable="columnCodUnitate" msprop:Generator_ColumnPropNameInRow="CodUnitate" msprop:Generator_ColumnPropNameInTable="CodUnitateColumn" msprop:Generator_UserColumnName="CodUnitate" type="xs:short" />
              <xs:element name="IDPartener" msprop:Generator_ColumnVarNameInTable="columnIDPartener" msprop:Generator_ColumnPropNameInRow="IDPartener" msprop:Generator_ColumnPropNameInTable="IDPartenerColumn" msprop:Generator_UserColumnName="IDPartener" type="xs:long" />
              <xs:element name="IDTipDocument" msprop:Generator_ColumnVarNameInTable="columnIDTipDocument" msprop:Generator_ColumnPropNameInRow="IDTipDocument" msprop:Generator_ColumnPropNameInTable="IDTipDocumentColumn" msprop:Generator_UserColumnName="IDTipDocument" type="xs:short" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Articole" msprop:Generator_TableClassName="ArticoleDataTable" msprop:Generator_TableVarName="tableArticole" msprop:Generator_RowChangedName="ArticoleRowChanged" msprop:Generator_TablePropName="Articole" msprop:Generator_RowDeletingName="ArticoleRowDeleting" msprop:Generator_RowChangingName="ArticoleRowChanging" msprop:Generator_RowEvHandlerName="ArticoleRowChangeEventHandler" msprop:Generator_RowDeletedName="ArticoleRowDeleted" msprop:Generator_RowClassName="ArticoleRow" msprop:Generator_UserTableName="Articole" msprop:Generator_RowEvArgName="ArticoleRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="IDArticol" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnIDArticol" msprop:Generator_ColumnPropNameInRow="IDArticol" msprop:Generator_ColumnPropNameInTable="IDArticolColumn" msprop:Generator_UserColumnName="IDArticol" type="xs:int" />
              <xs:element name="CodArticol" msprop:Generator_ColumnVarNameInTable="columnCodArticol" msprop:Generator_ColumnPropNameInRow="CodArticol" msprop:Generator_ColumnPropNameInTable="CodArticolColumn" msprop:Generator_UserColumnName="CodArticol">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Denumire" msprop:Generator_ColumnVarNameInTable="columnDenumire" msprop:Generator_ColumnPropNameInRow="Denumire" msprop:Generator_ColumnPropNameInTable="DenumireColumn" msprop:Generator_UserColumnName="Denumire">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="IDCategorie" msprop:Generator_ColumnVarNameInTable="columnIDCategorie" msprop:Generator_ColumnPropNameInRow="IDCategorie" msprop:Generator_ColumnPropNameInTable="IDCategorieColumn" msprop:Generator_UserColumnName="IDCategorie" type="xs:short" />
              <xs:element name="CodUnitate" msprop:Generator_ColumnVarNameInTable="columnCodUnitate" msprop:Generator_ColumnPropNameInRow="CodUnitate" msprop:Generator_ColumnPropNameInTable="CodUnitateColumn" msprop:Generator_UserColumnName="CodUnitate" type="xs:short" />
              <xs:element name="IDUnitateMasura" msprop:Generator_ColumnVarNameInTable="columnIDUnitateMasura" msprop:Generator_ColumnPropNameInRow="IDUnitateMasura" msprop:Generator_ColumnPropNameInTable="IDUnitateMasuraColumn" msprop:Generator_UserColumnName="IDUnitateMasura" type="xs:short" />
              <xs:element name="Cont" msprop:Generator_ColumnVarNameInTable="columnCont" msprop:Generator_ColumnPropNameInRow="Cont" msprop:Generator_ColumnPropNameInTable="ContColumn" msprop:Generator_UserColumnName="Cont">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ContCheltuiala" msprop:Generator_ColumnVarNameInTable="columnContCheltuiala" msprop:Generator_ColumnPropNameInRow="ContCheltuiala" msprop:Generator_ColumnPropNameInTable="ContCheltuialaColumn" msprop:Generator_UserColumnName="ContCheltuiala">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Greutate" msprop:Generator_ColumnVarNameInTable="columnGreutate" msprop:Generator_ColumnPropNameInRow="Greutate" msprop:Generator_ColumnPropNameInTable="GreutateColumn" msprop:Generator_UserColumnName="Greutate" type="xs:double" />
              <xs:element name="CotaTVA" msprop:Generator_ColumnVarNameInTable="columnCotaTVA" msprop:Generator_ColumnPropNameInRow="CotaTVA" msprop:Generator_ColumnPropNameInTable="CotaTVAColumn" msprop:Generator_UserColumnName="CotaTVA" type="xs:decimal" />
              <xs:element name="EsteServiciu" msprop:Generator_ColumnVarNameInTable="columnEsteServiciu" msprop:Generator_ColumnPropNameInRow="EsteServiciu" msprop:Generator_ColumnPropNameInTable="EsteServiciuColumn" msprop:Generator_UserColumnName="EsteServiciu" type="xs:boolean" />
              <xs:element name="ContVenit" msprop:Generator_ColumnVarNameInTable="columnContVenit" msprop:Generator_ColumnPropNameInRow="ContVenit" msprop:Generator_ColumnPropNameInTable="ContVenitColumn" msprop:Generator_UserColumnName="ContVenit" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="PretVanzare" msprop:Generator_ColumnVarNameInTable="columnPretVanzare" msprop:Generator_ColumnPropNameInRow="PretVanzare" msprop:Generator_ColumnPropNameInTable="PretVanzareColumn" msprop:Generator_UserColumnName="PretVanzare" type="xs:decimal" />
              <xs:element name="ArtAl" msprop:Generator_ColumnVarNameInTable="columnArtAl" msprop:Generator_ColumnPropNameInRow="ArtAl" msprop:Generator_ColumnPropNameInTable="ArtAlColumn" msprop:Generator_UserColumnName="ArtAl" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="40" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="PretVanzareValuta" msprop:Generator_ColumnVarNameInTable="columnPretVanzareValuta" msprop:Generator_ColumnPropNameInRow="PretVanzareValuta" msprop:Generator_ColumnPropNameInTable="PretVanzareValutaColumn" msprop:Generator_UserColumnName="PretVanzareValuta" type="xs:decimal" />
              <xs:element name="PretVanzareCodValuta" msprop:Generator_ColumnVarNameInTable="columnPretVanzareCodValuta" msprop:Generator_ColumnPropNameInRow="PretVanzareCodValuta" msprop:Generator_ColumnPropNameInTable="PretVanzareCodValutaColumn" msprop:Generator_UserColumnName="PretVanzareCodValuta" type="xs:short" />
              <xs:element name="MateriePrima" msprop:Generator_ColumnVarNameInTable="columnMateriePrima" msprop:Generator_ColumnPropNameInRow="MateriePrima" msprop:Generator_ColumnPropNameInTable="MateriePrimaColumn" msprop:Generator_UserColumnName="MateriePrima" type="xs:boolean" />
              <xs:element name="Lungime" msprop:Generator_ColumnVarNameInTable="columnLungime" msprop:Generator_ColumnPropNameInRow="Lungime" msprop:Generator_ColumnPropNameInTable="LungimeColumn" msprop:Generator_UserColumnName="Lungime" type="xs:double" minOccurs="0" />
              <xs:element name="Latime" msprop:Generator_ColumnVarNameInTable="columnLatime" msprop:Generator_ColumnPropNameInRow="Latime" msprop:Generator_ColumnPropNameInTable="LatimeColumn" msprop:Generator_UserColumnName="Latime" type="xs:double" minOccurs="0" />
              <xs:element name="Grosime" msprop:Generator_ColumnVarNameInTable="columnGrosime" msprop:Generator_ColumnPropNameInRow="Grosime" msprop:Generator_ColumnPropNameInTable="GrosimeColumn" msprop:Generator_UserColumnName="Grosime" type="xs:double" minOccurs="0" />
              <xs:element name="Raft" msprop:Generator_ColumnVarNameInTable="columnRaft" msprop:Generator_ColumnPropNameInRow="Raft" msprop:Generator_ColumnPropNameInTable="RaftColumn" msprop:Generator_UserColumnName="Raft" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="UnitatiMasura" msprop:Generator_TableClassName="UnitatiMasuraDataTable" msprop:Generator_TableVarName="tableUnitatiMasura" msprop:Generator_RowChangedName="UnitatiMasuraRowChanged" msprop:Generator_TablePropName="UnitatiMasura" msprop:Generator_RowDeletingName="UnitatiMasuraRowDeleting" msprop:Generator_RowChangingName="UnitatiMasuraRowChanging" msprop:Generator_RowEvHandlerName="UnitatiMasuraRowChangeEventHandler" msprop:Generator_RowDeletedName="UnitatiMasuraRowDeleted" msprop:Generator_RowClassName="UnitatiMasuraRow" msprop:Generator_UserTableName="UnitatiMasura" msprop:Generator_RowEvArgName="UnitatiMasuraRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="IDUnitateMasura" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnIDUnitateMasura" msprop:Generator_ColumnPropNameInRow="IDUnitateMasura" msprop:Generator_ColumnPropNameInTable="IDUnitateMasuraColumn" msprop:Generator_UserColumnName="IDUnitateMasura" type="xs:short" />
              <xs:element name="Denumire" msprop:Generator_ColumnVarNameInTable="columnDenumire" msprop:Generator_ColumnPropNameInRow="Denumire" msprop:Generator_ColumnPropNameInTable="DenumireColumn" msprop:Generator_UserColumnName="Denumire">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Compusa" msprop:Generator_ColumnVarNameInTable="columnCompusa" msprop:Generator_ColumnPropNameInRow="Compusa" msprop:Generator_ColumnPropNameInTable="CompusaColumn" msprop:Generator_UserColumnName="Compusa" type="xs:boolean" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Valuta" msprop:Generator_TableClassName="ValutaDataTable" msprop:Generator_TableVarName="tableValuta" msprop:Generator_RowChangedName="ValutaRowChanged" msprop:Generator_TablePropName="Valuta" msprop:Generator_RowDeletingName="ValutaRowDeleting" msprop:Generator_RowChangingName="ValutaRowChanging" msprop:Generator_RowEvHandlerName="ValutaRowChangeEventHandler" msprop:Generator_RowDeletedName="ValutaRowDeleted" msprop:Generator_RowClassName="ValutaRow" msprop:Generator_UserTableName="Valuta" msprop:Generator_RowEvArgName="ValutaRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="CodValuta" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnCodValuta" msprop:Generator_ColumnPropNameInRow="CodValuta" msprop:Generator_ColumnPropNameInTable="CodValutaColumn" msprop:Generator_UserColumnName="CodValuta" type="xs:short" />
              <xs:element name="Denumire" msprop:Generator_ColumnVarNameInTable="columnDenumire" msprop:Generator_ColumnPropNameInRow="Denumire" msprop:Generator_ColumnPropNameInTable="DenumireColumn" msprop:Generator_UserColumnName="Denumire">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Simbol" msprop:Generator_ColumnVarNameInTable="columnSimbol" msprop:Generator_ColumnPropNameInRow="Simbol" msprop:Generator_ColumnPropNameInTable="SimbolColumn" msprop:Generator_UserColumnName="Simbol">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Utilizat" msprop:Generator_ColumnVarNameInTable="columnUtilizat" msprop:Generator_ColumnPropNameInRow="Utilizat" msprop:Generator_ColumnPropNameInTable="UtilizatColumn" msprop:Generator_UserColumnName="Utilizat" type="xs:boolean" />
              <xs:element name="MonedaImplicita" msprop:Generator_ColumnVarNameInTable="columnMonedaImplicita" msprop:Generator_ColumnPropNameInRow="MonedaImplicita" msprop:Generator_ColumnPropNameInTable="MonedaImplicitaColumn" msprop:Generator_UserColumnName="MonedaImplicita" type="xs:boolean" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="FaresSetup" msprop:Generator_TableClassName="FaresSetupDataTable" msprop:Generator_TableVarName="tableFaresSetup" msprop:Generator_RowChangedName="FaresSetupRowChanged" msprop:Generator_TablePropName="FaresSetup" msprop:Generator_RowDeletingName="FaresSetupRowDeleting" msprop:Generator_RowChangingName="FaresSetupRowChanging" msprop:Generator_RowEvHandlerName="FaresSetupRowChangeEventHandler" msprop:Generator_RowDeletedName="FaresSetupRowDeleted" msprop:Generator_RowClassName="FaresSetupRow" msprop:Generator_UserTableName="FaresSetup" msprop:Generator_RowEvArgName="FaresSetupRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="PrimaryKey" msprop:Generator_ColumnVarNameInTable="columnPrimaryKey" msprop:Generator_ColumnPropNameInRow="PrimaryKey" msprop:Generator_ColumnPropNameInTable="PrimaryKeyColumn" msprop:Generator_UserColumnName="PrimaryKey" type="xs:short" />
              <xs:element name="CodUnitate" msprop:Generator_ColumnVarNameInTable="columnCodUnitate" msprop:Generator_ColumnPropNameInRow="CodUnitate" msprop:Generator_ColumnPropNameInTable="CodUnitateColumn" msprop:Generator_UserColumnName="CodUnitate" type="xs:short" />
              <xs:element name="FolosesteAdresa" msprop:Generator_ColumnVarNameInTable="columnFolosesteAdresa" msprop:Generator_ColumnPropNameInRow="FolosesteAdresa" msprop:Generator_ColumnPropNameInTable="FolosesteAdresaColumn" msprop:Generator_UserColumnName="FolosesteAdresa" type="xs:boolean" />
              <xs:element name="GolesteInainteImport" msprop:Generator_ColumnVarNameInTable="columnGolesteInainteImport" msprop:Generator_ColumnPropNameInRow="GolesteInainteImport" msprop:Generator_ColumnPropNameInTable="GolesteInainteImportColumn" msprop:Generator_UserColumnName="GolesteInainteImport" type="xs:boolean" />
              <xs:element name="ParteneriProprii" msprop:Generator_ColumnVarNameInTable="columnParteneriProprii" msprop:Generator_ColumnPropNameInRow="ParteneriProprii" msprop:Generator_ColumnPropNameInTable="ParteneriPropriiColumn" msprop:Generator_UserColumnName="ParteneriProprii" type="xs:boolean" />
              <xs:element name="IDSerie" msprop:Generator_ColumnVarNameInTable="columnIDSerie" msprop:Generator_ColumnPropNameInRow="IDSerie" msprop:Generator_ColumnPropNameInTable="IDSerieColumn" msprop:Generator_UserColumnName="IDSerie">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="AnCurent" msprop:Generator_ColumnVarNameInTable="columnAnCurent" msprop:Generator_ColumnPropNameInRow="AnCurent" msprop:Generator_ColumnPropNameInTable="AnCurentColumn" msprop:Generator_UserColumnName="AnCurent" type="xs:short" />
              <xs:element name="LunaCurenta" msprop:Generator_ColumnVarNameInTable="columnLunaCurenta" msprop:Generator_ColumnPropNameInRow="LunaCurenta" msprop:Generator_ColumnPropNameInTable="LunaCurentaColumn" msprop:Generator_UserColumnName="LunaCurenta" type="xs:short" />
              <xs:element name="ContArticolImplicit" msprop:Generator_ColumnVarNameInTable="columnContArticolImplicit" msprop:Generator_ColumnPropNameInRow="ContArticolImplicit" msprop:Generator_ColumnPropNameInTable="ContArticolImplicitColumn" msprop:Generator_UserColumnName="ContArticolImplicit" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ContCheltuialaArticolImplicit" msprop:Generator_ColumnVarNameInTable="columnContCheltuialaArticolImplicit" msprop:Generator_ColumnPropNameInRow="ContCheltuialaArticolImplicit" msprop:Generator_ColumnPropNameInTable="ContCheltuialaArticolImplicitColumn" msprop:Generator_UserColumnName="ContCheltuialaArticolImplicit" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CotaTVAImplicita" msprop:Generator_ColumnVarNameInTable="columnCotaTVAImplicita" msprop:Generator_ColumnPropNameInRow="CotaTVAImplicita" msprop:Generator_ColumnPropNameInTable="CotaTVAImplicitaColumn" msprop:Generator_UserColumnName="CotaTVAImplicita" type="xs:decimal" />
              <xs:element name="ComenziFaraTVA" msprop:Generator_ColumnVarNameInTable="columnComenziFaraTVA" msprop:Generator_ColumnPropNameInRow="ComenziFaraTVA" msprop:Generator_ColumnPropNameInTable="ComenziFaraTVAColumn" msprop:Generator_UserColumnName="ComenziFaraTVA" type="xs:boolean" />
              <xs:element name="AdresaLivrare1" msprop:Generator_ColumnVarNameInTable="columnAdresaLivrare1" msprop:Generator_ColumnPropNameInRow="AdresaLivrare1" msprop:Generator_ColumnPropNameInTable="AdresaLivrare1Column" msprop:Generator_UserColumnName="AdresaLivrare1" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="250" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="AdresaLivrare2" msprop:Generator_ColumnVarNameInTable="columnAdresaLivrare2" msprop:Generator_ColumnPropNameInRow="AdresaLivrare2" msprop:Generator_ColumnPropNameInTable="AdresaLivrare2Column" msprop:Generator_UserColumnName="AdresaLivrare2" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="250" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="AdresaLivrare3" msprop:Generator_ColumnVarNameInTable="columnAdresaLivrare3" msprop:Generator_ColumnPropNameInRow="AdresaLivrare3" msprop:Generator_ColumnPropNameInTable="AdresaLivrare3Column" msprop:Generator_UserColumnName="AdresaLivrare3" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="250" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="AfiseazaProprietarDocument" msprop:Generator_ColumnVarNameInTable="columnAfiseazaProprietarDocument" msprop:Generator_ColumnPropNameInRow="AfiseazaProprietarDocument" msprop:Generator_ColumnPropNameInTable="AfiseazaProprietarDocumentColumn" msprop:Generator_UserColumnName="AfiseazaProprietarDocument" type="xs:boolean" />
              <xs:element name="FaraCodArticol" msprop:Generator_ColumnVarNameInTable="columnFaraCodArticol" msprop:Generator_ColumnPropNameInRow="FaraCodArticol" msprop:Generator_ColumnPropNameInTable="FaraCodArticolColumn" msprop:Generator_UserColumnName="FaraCodArticol" type="xs:boolean" />
              <xs:element name="FolosesteVarinata" msprop:Generator_ColumnVarNameInTable="columnFolosesteVarinata" msprop:Generator_ColumnPropNameInRow="FolosesteVarinata" msprop:Generator_ColumnPropNameInTable="FolosesteVarinataColumn" msprop:Generator_UserColumnName="FolosesteVarinata" type="xs:boolean" />
              <xs:element name="FolosesteTermenLivrare" msprop:Generator_ColumnVarNameInTable="columnFolosesteTermenLivrare" msprop:Generator_ColumnPropNameInRow="FolosesteTermenLivrare" msprop:Generator_ColumnPropNameInTable="FolosesteTermenLivrareColumn" msprop:Generator_UserColumnName="FolosesteTermenLivrare" type="xs:boolean" />
              <xs:element name="UtilizeazaDepartament" msprop:Generator_ColumnVarNameInTable="columnUtilizeazaDepartament" msprop:Generator_ColumnPropNameInRow="UtilizeazaDepartament" msprop:Generator_ColumnPropNameInTable="UtilizeazaDepartamentColumn" msprop:Generator_UserColumnName="UtilizeazaDepartament" type="xs:boolean" />
              <xs:element name="CotaTVADetaliuDocument" msprop:Generator_ColumnVarNameInTable="columnCotaTVADetaliuDocument" msprop:Generator_ColumnPropNameInRow="CotaTVADetaliuDocument" msprop:Generator_ColumnPropNameInTable="CotaTVADetaliuDocumentColumn" msprop:Generator_UserColumnName="CotaTVADetaliuDocument" type="xs:boolean" />
              <xs:element name="RegimFiscalDetaliu" msprop:Generator_ColumnVarNameInTable="columnRegimFiscalDetaliu" msprop:Generator_ColumnPropNameInRow="RegimFiscalDetaliu" msprop:Generator_ColumnPropNameInTable="RegimFiscalDetaliuColumn" msprop:Generator_UserColumnName="RegimFiscalDetaliu" type="xs:boolean" />
              <xs:element name="IDSeriePlati" msprop:Generator_ColumnVarNameInTable="columnIDSeriePlati" msprop:Generator_ColumnPropNameInRow="IDSeriePlati" msprop:Generator_ColumnPropNameInTable="IDSeriePlatiColumn" msprop:Generator_UserColumnName="IDSeriePlati">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="FolosesteValoareCuAdaos" msprop:Generator_ColumnVarNameInTable="columnFolosesteValoareCuAdaos" msprop:Generator_ColumnPropNameInRow="FolosesteValoareCuAdaos" msprop:Generator_ColumnPropNameInTable="FolosesteValoareCuAdaosColumn" msprop:Generator_UserColumnName="FolosesteValoareCuAdaos" type="xs:boolean" />
              <xs:element name="SalveazaCuUrmatorulNumar" msprop:Generator_ColumnVarNameInTable="columnSalveazaCuUrmatorulNumar" msprop:Generator_ColumnPropNameInRow="SalveazaCuUrmatorulNumar" msprop:Generator_ColumnPropNameInTable="SalveazaCuUrmatorulNumarColumn" msprop:Generator_UserColumnName="SalveazaCuUrmatorulNumar" type="xs:boolean" />
              <xs:element name="SalvareCuAdaugare" msprop:Generator_ColumnVarNameInTable="columnSalvareCuAdaugare" msprop:Generator_ColumnPropNameInRow="SalvareCuAdaugare" msprop:Generator_ColumnPropNameInTable="SalvareCuAdaugareColumn" msprop:Generator_UserColumnName="SalvareCuAdaugare" type="xs:boolean" />
              <xs:element name="FolosesteObservatii" msprop:Generator_ColumnVarNameInTable="columnFolosesteObservatii" msprop:Generator_ColumnPropNameInRow="FolosesteObservatii" msprop:Generator_ColumnPropNameInTable="FolosesteObservatiiColumn" msprop:Generator_UserColumnName="FolosesteObservatii" type="xs:boolean" />
              <xs:element name="CaleD394" msprop:Generator_ColumnVarNameInTable="columnCaleD394" msprop:Generator_ColumnPropNameInRow="CaleD394" msprop:Generator_ColumnPropNameInTable="CaleD394Column" msprop:Generator_UserColumnName="CaleD394" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="250" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="AfiseazaDoarDocumenteleCurente" msprop:Generator_ColumnVarNameInTable="columnAfiseazaDoarDocumenteleCurente" msprop:Generator_ColumnPropNameInRow="AfiseazaDoarDocumenteleCurente" msprop:Generator_ColumnPropNameInTable="AfiseazaDoarDocumenteleCurenteColumn" msprop:Generator_UserColumnName="AfiseazaDoarDocumenteleCurente" type="xs:boolean" />
              <xs:element name="ContVenitArticolImplicit" msprop:Generator_ColumnVarNameInTable="columnContVenitArticolImplicit" msprop:Generator_ColumnPropNameInRow="ContVenitArticolImplicit" msprop:Generator_ColumnPropNameInTable="ContVenitArticolImplicitColumn" msprop:Generator_UserColumnName="ContVenitArticolImplicit" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="AfiseazaSemnaturiTiparire" msprop:Generator_ColumnVarNameInTable="columnAfiseazaSemnaturiTiparire" msprop:Generator_ColumnPropNameInRow="AfiseazaSemnaturiTiparire" msprop:Generator_ColumnPropNameInTable="AfiseazaSemnaturiTiparireColumn" msprop:Generator_UserColumnName="AfiseazaSemnaturiTiparire" type="xs:boolean" />
              <xs:element name="IDSerieBC" msprop:Generator_ColumnVarNameInTable="columnIDSerieBC" msprop:Generator_ColumnPropNameInRow="IDSerieBC" msprop:Generator_ColumnPropNameInTable="IDSerieBCColumn" msprop:Generator_UserColumnName="IDSerieBC">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="IDSerieBF" msprop:Generator_ColumnVarNameInTable="columnIDSerieBF" msprop:Generator_ColumnPropNameInRow="IDSerieBF" msprop:Generator_ColumnPropNameInTable="IDSerieBFColumn" msprop:Generator_UserColumnName="IDSerieBF">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="GestiuneaStocurilor" msprop:Generator_ColumnVarNameInTable="columnGestiuneaStocurilor" msprop:Generator_ColumnPropNameInRow="GestiuneaStocurilor" msprop:Generator_ColumnPropNameInTable="GestiuneaStocurilorColumn" msprop:Generator_UserColumnName="GestiuneaStocurilor" type="xs:boolean" />
              <xs:element name="Valuta" msprop:Generator_ColumnVarNameInTable="columnValuta" msprop:Generator_ColumnPropNameInRow="Valuta" msprop:Generator_ColumnPropNameInTable="ValutaColumn" msprop:Generator_UserColumnName="Valuta" type="xs:boolean" />
              <xs:element name="Bugetara" msprop:Generator_ColumnVarNameInTable="columnBugetara" msprop:Generator_ColumnPropNameInRow="Bugetara" msprop:Generator_ColumnPropNameInTable="BugetaraColumn" msprop:Generator_UserColumnName="Bugetara" type="xs:boolean" />
              <xs:element name="JurnalImplicit" msprop:Generator_ColumnVarNameInTable="columnJurnalImplicit" msprop:Generator_ColumnPropNameInRow="JurnalImplicit" msprop:Generator_ColumnPropNameInTable="JurnalImplicitColumn" msprop:Generator_UserColumnName="JurnalImplicit" type="xs:int" minOccurs="0" />
              <xs:element name="ArtAlImplicit" msprop:Generator_ColumnVarNameInTable="columnArtAlImplicit" msprop:Generator_ColumnPropNameInRow="ArtAlImplicit" msprop:Generator_ColumnPropNameInTable="ArtAlImplicitColumn" msprop:Generator_UserColumnName="ArtAlImplicit" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="40" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ValutaImplicita" msprop:Generator_ColumnVarNameInTable="columnValutaImplicita" msprop:Generator_ColumnPropNameInRow="ValutaImplicita" msprop:Generator_ColumnPropNameInTable="ValutaImplicitaColumn" msprop:Generator_UserColumnName="ValutaImplicita" type="xs:short" />
              <xs:element name="FolosesteTVAArticol" msprop:Generator_ColumnVarNameInTable="columnFolosesteTVAArticol" msprop:Generator_ColumnPropNameInRow="FolosesteTVAArticol" msprop:Generator_ColumnPropNameInTable="FolosesteTVAArticolColumn" msprop:Generator_UserColumnName="FolosesteTVAArticol" type="xs:boolean" minOccurs="0" />
              <xs:element name="Productie" msprop:Generator_ColumnVarNameInTable="columnProductie" msprop:Generator_ColumnPropNameInRow="Productie" msprop:Generator_ColumnPropNameInTable="ProductieColumn" msprop:Generator_UserColumnName="Productie" type="xs:boolean" />
              <xs:element name="IDBancaImplicita" msprop:Generator_ColumnVarNameInTable="columnIDBancaImplicita" msprop:Generator_ColumnPropNameInRow="IDBancaImplicita" msprop:Generator_ColumnPropNameInTable="IDBancaImplicitaColumn" msprop:Generator_UserColumnName="IDBancaImplicita" type="xs:short" />
              <xs:element name="ImplementareAmbalaje" msprop:Generator_ColumnVarNameInTable="columnImplementareAmbalaje" msprop:Generator_ColumnPropNameInRow="ImplementareAmbalaje" msprop:Generator_ColumnPropNameInTable="ImplementareAmbalajeColumn" msprop:Generator_UserColumnName="ImplementareAmbalaje" type="xs:boolean" />
              <xs:element name="AreDocGestStoc" msprop:Generator_ColumnVarNameInTable="columnAreDocGestStoc" msprop:Generator_ColumnPropNameInRow="AreDocGestStoc" msprop:Generator_ColumnPropNameInTable="AreDocGestStocColumn" msprop:Generator_UserColumnName="AreDocGestStoc" type="xs:boolean" />
              <xs:element name="AvizExpeditieCuTVA" msprop:Generator_ColumnVarNameInTable="columnAvizExpeditieCuTVA" msprop:Generator_ColumnPropNameInRow="AvizExpeditieCuTVA" msprop:Generator_ColumnPropNameInTable="AvizExpeditieCuTVAColumn" msprop:Generator_UserColumnName="AvizExpeditieCuTVA" type="xs:boolean" />
              <xs:element name="IDSerieAE" msprop:Generator_ColumnVarNameInTable="columnIDSerieAE" msprop:Generator_ColumnPropNameInRow="IDSerieAE" msprop:Generator_ColumnPropNameInTable="IDSerieAEColumn" msprop:Generator_UserColumnName="IDSerieAE" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="IDSerieFACT" msprop:Generator_ColumnVarNameInTable="columnIDSerieFACT" msprop:Generator_ColumnPropNameInRow="IDSerieFACT" msprop:Generator_ColumnPropNameInTable="IDSerieFACTColumn" msprop:Generator_UserColumnName="IDSerieFACT" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="IDSerieCHIT" msprop:Generator_ColumnVarNameInTable="columnIDSerieCHIT" msprop:Generator_ColumnPropNameInRow="IDSerieCHIT" msprop:Generator_ColumnPropNameInTable="IDSerieCHITColumn" msprop:Generator_UserColumnName="IDSerieCHIT" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ComandaFaraPreturi" msprop:Generator_ColumnVarNameInTable="columnComandaFaraPreturi" msprop:Generator_ColumnPropNameInRow="ComandaFaraPreturi" msprop:Generator_ColumnPropNameInTable="ComandaFaraPreturiColumn" msprop:Generator_UserColumnName="ComandaFaraPreturi" type="xs:boolean" />
              <xs:element name="ProdusePePartener" msprop:Generator_ColumnVarNameInTable="columnProdusePePartener" msprop:Generator_ColumnPropNameInRow="ProdusePePartener" msprop:Generator_ColumnPropNameInTable="ProdusePePartenerColumn" msprop:Generator_UserColumnName="ProdusePePartener" type="xs:boolean" />
              <xs:element name="DenumireNumeric1" msprop:Generator_ColumnVarNameInTable="columnDenumireNumeric1" msprop:Generator_ColumnPropNameInRow="DenumireNumeric1" msprop:Generator_ColumnPropNameInTable="DenumireNumeric1Column" msprop:Generator_UserColumnName="DenumireNumeric1">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DenumireNumeric2" msprop:Generator_ColumnVarNameInTable="columnDenumireNumeric2" msprop:Generator_ColumnPropNameInRow="DenumireNumeric2" msprop:Generator_ColumnPropNameInTable="DenumireNumeric2Column" msprop:Generator_UserColumnName="DenumireNumeric2">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DenumireNumeric3" msprop:Generator_ColumnVarNameInTable="columnDenumireNumeric3" msprop:Generator_ColumnPropNameInRow="DenumireNumeric3" msprop:Generator_ColumnPropNameInTable="DenumireNumeric3Column" msprop:Generator_UserColumnName="DenumireNumeric3">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="DocumenteDetaliuLink" msprop:Generator_TableClassName="DocumenteDetaliuLinkDataTable" msprop:Generator_TableVarName="tableDocumenteDetaliuLink" msprop:Generator_RowChangedName="DocumenteDetaliuLinkRowChanged" msprop:Generator_TablePropName="DocumenteDetaliuLink" msprop:Generator_RowDeletingName="DocumenteDetaliuLinkRowDeleting" msprop:Generator_RowChangingName="DocumenteDetaliuLinkRowChanging" msprop:Generator_RowEvHandlerName="DocumenteDetaliuLinkRowChangeEventHandler" msprop:Generator_RowDeletedName="DocumenteDetaliuLinkRowDeleted" msprop:Generator_RowClassName="DocumenteDetaliuLinkRow" msprop:Generator_UserTableName="DocumenteDetaliuLink" msprop:Generator_RowEvArgName="DocumenteDetaliuLinkRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="IDDocDetaliuLink" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnIDDocDetaliuLink" msprop:Generator_ColumnPropNameInRow="IDDocDetaliuLink" msprop:Generator_ColumnPropNameInTable="IDDocDetaliuLinkColumn" msprop:Generator_UserColumnName="IDDocDetaliuLink" type="xs:long" />
              <xs:element name="IDDocDetaliuSursa" msprop:Generator_ColumnVarNameInTable="columnIDDocDetaliuSursa" msprop:Generator_ColumnPropNameInRow="IDDocDetaliuSursa" msprop:Generator_ColumnPropNameInTable="IDDocDetaliuSursaColumn" msprop:Generator_UserColumnName="IDDocDetaliuSursa" type="xs:long" />
              <xs:element name="IDDocDetaliuDest" msprop:Generator_ColumnVarNameInTable="columnIDDocDetaliuDest" msprop:Generator_ColumnPropNameInRow="IDDocDetaliuDest" msprop:Generator_ColumnPropNameInTable="IDDocDetaliuDestColumn" msprop:Generator_UserColumnName="IDDocDetaliuDest" type="xs:long" />
              <xs:element name="Cantitate" msprop:Generator_ColumnVarNameInTable="columnCantitate" msprop:Generator_ColumnPropNameInRow="Cantitate" msprop:Generator_ColumnPropNameInTable="CantitateColumn" msprop:Generator_UserColumnName="Cantitate" type="xs:decimal" minOccurs="0" />
              <xs:element name="Tip" msprop:Generator_ColumnVarNameInTable="columnTip" msprop:Generator_ColumnPropNameInRow="Tip" msprop:Generator_ColumnPropNameInTable="TipColumn" msprop:Generator_UserColumnName="Tip">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="TipDocument" msprop:Generator_TableClassName="TipDocumentDataTable" msprop:Generator_TableVarName="tableTipDocument" msprop:Generator_TablePropName="TipDocument" msprop:Generator_RowDeletingName="TipDocumentRowDeleting" msprop:Generator_RowChangingName="TipDocumentRowChanging" msprop:Generator_RowEvHandlerName="TipDocumentRowChangeEventHandler" msprop:Generator_RowDeletedName="TipDocumentRowDeleted" msprop:Generator_UserTableName="TipDocument" msprop:Generator_RowChangedName="TipDocumentRowChanged" msprop:Generator_RowEvArgName="TipDocumentRowChangeEvent" msprop:Generator_RowClassName="TipDocumentRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="IDTipDocument" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnIDTipDocument" msprop:Generator_ColumnPropNameInRow="IDTipDocument" msprop:Generator_ColumnPropNameInTable="IDTipDocumentColumn" msprop:Generator_UserColumnName="IDTipDocument" type="xs:short" />
              <xs:element name="Denumire" msprop:Generator_ColumnVarNameInTable="columnDenumire" msprop:Generator_ColumnPropNameInRow="Denumire" msprop:Generator_ColumnPropNameInTable="DenumireColumn" msprop:Generator_UserColumnName="Denumire">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="TipOperatie" msprop:Generator_ColumnVarNameInTable="columnTipOperatie" msprop:Generator_ColumnPropNameInRow="TipOperatie" msprop:Generator_ColumnPropNameInTable="TipOperatieColumn" msprop:Generator_UserColumnName="TipOperatie">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="SePlateste" msprop:Generator_ColumnVarNameInTable="columnSePlateste" msprop:Generator_ColumnPropNameInRow="SePlateste" msprop:Generator_ColumnPropNameInTable="SePlatesteColumn" msprop:Generator_UserColumnName="SePlateste" type="xs:boolean" />
              <xs:element name="ModificaStoc" msprop:Generator_ColumnVarNameInTable="columnModificaStoc" msprop:Generator_ColumnPropNameInRow="ModificaStoc" msprop:Generator_ColumnPropNameInTable="ModificaStocColumn" msprop:Generator_UserColumnName="ModificaStoc" type="xs:boolean" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:fares_viewComenziNeonorate" />
      <xs:field xpath="mstns:IDDocumentDetaliu" />
    </xs:unique>
    <xs:unique name="Articole_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Articole" />
      <xs:field xpath="mstns:IDArticol" />
    </xs:unique>
    <xs:unique name="UnitatiMasura_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:UnitatiMasura" />
      <xs:field xpath="mstns:IDUnitateMasura" />
    </xs:unique>
    <xs:unique name="Valuta_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Valuta" />
      <xs:field xpath="mstns:CodValuta" />
    </xs:unique>
    <xs:unique name="FaresSetup_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:FaresSetup" />
      <xs:field xpath="mstns:PrimaryKey" />
      <xs:field xpath="mstns:CodUnitate" />
    </xs:unique>
    <xs:unique name="DocumenteDetaliuLink_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:DocumenteDetaliuLink" />
      <xs:field xpath="mstns:IDDocDetaliuLink" />
    </xs:unique>
    <xs:unique name="TipDocument_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:TipDocument" />
      <xs:field xpath="mstns:IDTipDocument" />
    </xs:unique>
  </xs:element>
  <xs:annotation>
    <xs:appinfo>
      <msdata:Relationship name="FK_Articole_UnitatiMasura" msdata:parent="UnitatiMasura" msdata:child="Articole" msdata:parentkey="IDUnitateMasura" msdata:childkey="IDUnitateMasura" msprop:Generator_UserChildTable="Articole" msprop:Generator_ChildPropName="GetArticoleRows" msprop:Generator_UserRelationName="FK_Articole_UnitatiMasura" msprop:Generator_ParentPropName="UnitatiMasuraRow" msprop:Generator_RelationVarName="relationFK_Articole_UnitatiMasura" msprop:Generator_UserParentTable="UnitatiMasura" />
      <msdata:Relationship name="FK_Articole_Valuta" msdata:parent="Valuta" msdata:child="Articole" msdata:parentkey="CodValuta" msdata:childkey="PretVanzareCodValuta" msprop:Generator_UserChildTable="Articole" msprop:Generator_ChildPropName="GetArticoleRows" msprop:Generator_UserRelationName="FK_Articole_Valuta" msprop:Generator_ParentPropName="ValutaRow" msprop:Generator_RelationVarName="relationFK_Articole_Valuta" msprop:Generator_UserParentTable="Valuta" />
      <msdata:Relationship name="FK_FaresSetul_Valuta" msdata:parent="Valuta" msdata:child="FaresSetup" msdata:parentkey="CodValuta" msdata:childkey="ValutaImplicita" msprop:Generator_UserChildTable="FaresSetup" msprop:Generator_ChildPropName="GetFaresSetupRows" msprop:Generator_UserRelationName="FK_FaresSetul_Valuta" msprop:Generator_RelationVarName="relationFK_FaresSetul_Valuta" msprop:Generator_UserParentTable="Valuta" msprop:Generator_ParentPropName="ValutaRow" />
    </xs:appinfo>
  </xs:annotation>
</xs:schema>